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.

edit delete
are you sure?
asked Ramon Tan

1 answer

Have you downloaded and installed the ACE components?


After, you can check your appropiate connection string



edit delete
are you sure?
answered José Mª Fueyo

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions