Convert a previous-version database to Microsoft Access 2000

1. Make a backup copy of the Access database you're going to convert, to keep until you're comfortable working with the Microsoft Access 2000 database.
   
   
2. Close the Microsoft Access database you're going to convert.

   If the Access database is a multiuser database located on a server or in a shared folder, make sure that no one else has it open.

3. In Microsoft Access 2000, point to Database Utilities on the Tools menu; point to Convert Database and then click To Current Access Database Version.
   
   
4. In the Database To Convert From dialog box, select the database you want to convert and then click Convert.
   
   
5. In the Convert Database Into dialog box, do one of the following:
   • Type a new name (without the .mdb extension) for the Microsoft Access 2000 database file.
     
     
   • Select a different location for the Microsoft Access 97 database file. (You can keep the same name, or change it.)

   You cannot convert an Access database into a file with the same name and location as the original database.

6. Click Save.

Microsoft Access converts the database to Access 2000 format.

Notes

• You can convert a secured Access database. However, user-level security no longer protects modules. You can protect the modules in the converted Access database by protecting the Visual Basic for Applications (VBA) code with a password.
  
  
• When you convert a previous-version Microsoft Access database that has linked tables, make sure that the external tables are in the same folder that they were originally in. If Microsoft Access can't find the tables that are linked to a database that's being converted, you won't be able to use the converted database. Once you convert the Access database, you can move these tables and use the Linked Table Manager to re-link them. Converting a database that has tables linked to it does not convert the linked tables.
  
  
• You can also convert a previous-version Access database by importing its database objects into a new Access 2000 database. You can use this method if you don't want all of objects in the previous-version database to exist in the Access 2000 database.