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.
Have you downloaded and installed the ACE components?
After, you can check your appropiate connection string