MSQuery Err: "Obsolete Database Format" with Access Database

 Last reviewed: September 12, 1996
Article ID: Q115469
The information in this article applies to:
  • Microsoft Query for Windows, versions 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
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.

KBCategory: kbinterop
KBSubcategory: xlquery xlwin

Additional reference words: 1.00 5.00 5.00a 5.00c msquery err msg



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.