MSQuery Err: "Obsolete Database Format" with Access Database

The information in this article applies to:

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 :


Last Reviewed: October 11, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.