The win7 data source (ODBC) configuration is only the sqlsever driver ???

When debugging the Redbook Example 2 code today, we need to create an ODBC data source and then open the Data Source Creation form, and find that only the data source driver of sqlsever is available, instead of the access data source. What should we do ???

Why is this happening:

 

It is because the 64-bit windows Windows OS running C: \ windows \ system32 \ odbcad32.exe by default.

Open the "ODBC data source Manager" window, there is no access to the data source

 

How to do this:

 

If you are a win7 64-bit system, what you need to run is

C: \ windows \ syswow64 \ odbcad32.exe

Open the "ODBC data source Manager" window, click "add", open the "Create a new data source" window, select the Microsoft Access Driver (*. mdb) option, and then wait,

If you are a 32-bit win7 system, what you need to run is

C: \ windows \ system32 \ odbcad32.exe

 

.