Statistics Open Database Query - Microsoft Access ODBC Driver Password requested

Technote (troubleshooting)


Problem(Abstract)

When opening a Database query in Statistics 20 and selecting New Query and then my MS Access (.mdb) driver, the SPSS wizard is requesting a password.

Symptom

---------------------------
Microsoft ODBC Administrator
---------------------------
The setup routines for the Driver do Microsoft Access (*.mdb) ODBC driver could not be loaded due to system error code 126.
---------------------------
OK
---------------------------


Cause

You are either trying to use an old driver (Microsoft Access Database Driver (.mdb) or the location of driver has been changed.
The error indicates that the driver cannot be found.

Environment

Windows 7 64-bit Microsoft Office 2010 installed.

Diagnosing the problem

Launched the ODBC Data Source Administrator and had the user click on the MS Access Database under the User DSN and click on the Configure button.

Error:
---------------------------
Microsoft ODBC Administrator
---------------------------
The setup routines for the Driver do Microsoft Access (*.mdb) ODBC driver could not be loaded due to system error code 126.
---------------------------
OK
---------------------------

Resolving the problem

Option 1:



Remove the old driver and add a new driver.
To do this launch the ODBC Data Source Administrator, click on the old driver and click the 'Remove' button.
Under the User DSN tab click on the 'Add' button.
Select the new MS Access Database Driver click on 'Finish', give it a name and click on the 'OK' button.
Use that new configured MS Access Database Driver in the Open Database Query Wizard

Option 2:

If you know the Login and Password, add the requested information in the ODBC Data Source Administrator.

Under the User DSN tab, select the Data Source and click "Configure"

Under ODBC Microsoft Access Setup, click Advanced

Under Set Advanced Options, enter the User id/Login Name and password and click "OK"

Your file should open in the Open Database Query Wizard


Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Statistics

Software version:

20.0

Operating system(s):

Windows

Reference #:

1605408

Modified date:

2013-10-02

Translate my page

Machine Translation

Content navigation