ACC97: Cannot Run Microsoft Access 97 Database in Earlier Versions (159734)


The information in this article applies to:

  • Microsoft Access 97
This article was previously published under Q159734
Novice: Requires knowledge of the user interface on single-user computers.

SUMMARY

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.
Modification Type:MajorLast Reviewed:10/20/2003
Keywords:kbinfo KB159734
©2003 Microsoft Corporation. All rights reserved.