Fix missing references after converting an Access 2000 database to Access 97

You can convert code that uses Data Access Objects (DAO) back to Microsoft Access 97, but you may receive a message that your computer is missing at least one of the Access 97 object libraries. Use this procedure to fix the missing references.

1. Convert the Microsoft Access 2000 database to Microsoft Access 97. When you receive a message that your computer is missing at least one of the Access 97 object libraries, click OK.
   
   
2. Open the converted Access database in Microsoft Access 97.
   
   
3. Open a module in the database.
   
   
4. On the Tools menu, click References.
   
   
5. In the Available References box, clear the check boxes next to any missing references, and set a reference to the Microsoft DAO 3.51 Object Library.

Note   Unlike Access 2000, Access 97 is not designed to work with ActiveX Data Objects (ADO).