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.

0
edit delete
are you sure?
asked Ramon Tan

1 answer

Hi Have you downloaded and installed the ACE components?

https://www.microsoft.com/en-US/download/details.aspx?id=23734

After, you can check your appropiate connection string

https://www.connectionstrings.com/ace-oledb-12-0/

Regards,

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

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions