What is the Connection string for ACCESS 2007 .mdb on Windows 7 (64-bit)?

I have tried the following variations of the same statement in Powershell 5.1:

$objCon.Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\MyDocuments\WWW.mdb")
$objCon.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\MyDocuments\WWW.mdb")

I keep getting the message: "Provider cannot be found, may not be properly installed." on both

I have Access 2007 on my PC, installed as part of Office 2007. I have Windows 7 64-bit.
Would be grateful for any appropriate advice, tips or guidance.

Thank you in advance.

1 answer

Have you downloaded and installed the ACE components?


After, you can check your appropiate connection string