Access Driver ODBC Driver Not Found

[armsys]

It's a non-issue of Macro Scheduler.
It's related to dbconnect.
Platform: Win 7 Ultimate x64
In ODBC Data Source Administrator (%windir%\system32\odbcad32.exe), clicking "Configure..." button will pop up an error message box:
Microsoft ODBC Administrator
ODBC Administrator
The setup routines for the Microsoft Access Driver (*.mdb, *.accdb) ODBC driver could not be found. Please reinstall the driver.
What should I do? How can I construct a connection string for an Access table/query?

[armsys]

I solve the first problem. The actual ODBC Administrator I should run is:
C:\Windows\SysWOW64\odbcad32.exe. That runs perfectly free of any error.
The Search in Windows 7 Start points to the 64-bit ODBC Administrator.

Now the 2nd part of my question is how to construct a Connection string to my Access tables/queries.
Suppose a sample Access database, C:\Temp\Northwind.accdb, what's the proper syntax to connect it?

Please help. Thanks.

[adroege]

I have used this resource in the past with good results

Code: Select all

http://www.connectionstrings.com/

Enjoy|!

[armsys]

Hi adroege,
Absolutely amazing eye-opening great site. Thanks a lot.