ACC97: Can't Run MS Access 97 Database in Earlier Versions

 Last reviewed: February 4, 1998
Article ID: Q159734
The information in this article applies to:
  • Microsoft Access 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

The database file format in Microsoft Access 97 is different from the file format in earlier versions; however, you can export tables from a Microsoft Access 97 database to a database created by an earlier version.

MORE INFORMATION

If you need both Microsoft Access 97 users and users of an earlier version of Microsoft Access to share the same data, you have two alternatives:

  • You can open (or enable) the database. The Open option will leave your database unchanged, so you will be able to share it with users of earlier versions. You can make changes to the data, but you will not be able to make design changes to the database in Microsoft Access 97.

    NOTE: Even though the Open option leaves your original database unchanged, there may be some conversion issues that apply if you are sharing your database between Microsoft Access 95 and Microsoft Access 97.

  • You can create a front-end database for each version of Microsoft Access that will be accessing the data. The front-end should contain all of the objects, except tables. Move the tables to a back-end database that is in the format of the earliest version of Microsoft Access that will be accessing the data. Each of the front-end databases can then link (or attach) the tables in the back-end.

REFERENCES

For more information about compatibility with earlier versions of Microsoft Access, search the Microsoft Access 97 Help Index for "compatibility," or ask the Microsoft Access 97 Office Assistant. 

Keywords          : kbfaq
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbinfo

================================================================================

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: February 4, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.