Connect to Access 2003 Database (32-bit) on Windows 7 (64-bit)

May 20, 2014 at 4:55 PM
Is this possible? When I try the various formats for the connections field and get the following message...

"The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."

Thanks in advance
Coordinator
May 20, 2014 at 10:53 PM
As with all the connections it depends on your system configuration. These days Access is getting harder by default, the best resource I have found is

https://www.connectionstrings.com/

specifically for your case - https://www.connectionstrings.com/access/

The tool relies on your system configuration so if you have JET installed etc then that connection you tried would work but without the JET drivers you get that "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine" error...