MSQuery Err: "Obsolete Database Format" with Access Database

ID: Q115469

The information in this article applies to:

Microsoft Query for Windows, version 1.0
Microsoft Excel for Windows, versions 5.0, 5.0c

SYMPTOMS

When you use Microsoft Query to query a Microsoft Access version 2.0 table, you receive the following error messages:

Obsolete Database Format

-and-

Couldn't add data source

CAUSE

This problem occurs when you try to query a Microsoft Access version 2.0 table using the ODBC driver for Microsoft Access version 1.0 and 1.1 tables.

MORE INFORMATION

The driver that shipped with the Microsoft ODBC Drivers version 1.0 Fulfillment Kit supports Microsoft Access version 1.0 and 1.1 tables. The filename and version for this driver are:

Driver: Access Data
Filename: SIMBA.DLL
Version: 1.01.2115

The following driver is required to query Microsoft Access version 2.0 database files:

Driver: Access 2.0 for MS Office
Filename: ODBCJT16.DLL
Version: 1.00.1521

NOTE: Because there are several versions of Windows, the following steps may be different on your computer. If they are, please consult your product documentation to complete these steps.

To check for the correct filename and version, do the following:

In Program Manager, double-click the Control Panel icon in the Main Group.

Double-click the ODBC icon.

Select the Drivers button.

Select the driver you want information about.

Choose the About button.

If the Access 2.0 for Microsoft Office ODBC driver is not installed on your machine, run the Microsoft Access 2.0 custom Setup and install the ODBC support.

Additional query words: 5.00a 5.00c msquery err msg

Keywords : xlquery xlwin
Version : WINDOWS:1.0,5.0,5.0c
Platform : WINDOWS
Issue type :