Microsoft KB Archive/115469

{|
 * width="100%"|

MSQuery Err: "Obsolete Database Format" with Access Database

 * }

-

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:


 * 1) In Program Manager, double-click the Control Panel icon in the Main Group.
 * 2) Double-click the ODBC icon.
 * 3) Select the Drivers button.
 * 4) Select the driver you want information about.
 * 5) 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 :

Technology :