About converting an Access 2000 database to Access 97

You can convert a Microsoft Access 2000 database to an Access 97 database if it is not a member of a replica set. Any functionality that is specific to Access 2000 is lost when you convert the database to Access 97.

Converting an Access 2000 database to an Access 97 database makes the following changes to the converted database.

• Links to data access pages are lost.
  
  
• Data that relies on Unicode support in Access 2000 might not be converted correctly. Access 97 uses characters from only a single code page — a numbered set of 256 characters. For example, an Access 97 database might use only ANSI characters. During conversion, the collating order of the original Access 2000 database determines which set of characters the resulting Access 97 database can use; any characters that are not in this set are not converted correctly.
  
  
• An Access 2000 database containing a table with a FieldSize property of Decimal cannot be converted to Access 97. You must change the FieldSize property to another value such as Single or Double, or you must change the field's data type to Currency before you can successfully convert the database.

If you are converting a secured Access database, the user account that you use to log on must have the following permissions:

• Open/Run and Open Exclusive permissions for the database itself. Read Design permissions for all objects in the database.
  
  
• To secure the converted database, you must open it in Microsoft Access 97 and apply user-level security.

If you have protected the Access database with a password, you can convert it without removing the password. If you have protected the Microsoft Visual Basic for Applications (VBA) code with a password, you must supply the password in the Visual Basic Environment.