Your converted database may not function as expected when you convert an Access database in Access 2002 from an earlier version of Access

When you convert a Microsoft Access database in Microsoft Access 2002 from an earlier version of Microsoft Access, your converted database may not function as expected.

For example, if you try to run a macro that is contained in your converted database, you may receive the following error message:

This problem occurs because during the conversion of the earlier Access database, references to earlier Data Access Objects (DAO) components were removed but references to newer DAO components were not added.

For example, the earlier Microsoft DAO 2.5/3.5 Compatibility Library was removed during the conversion of the earlier Access database, but the later Microsoft DAO 3.6 Object Library was not added to the Available References list in the Microsoft Visual Basic Editor.

How to obtain the hotfix

This issue is fixed in the Access 2002 post-Service Pack 3 Hotfix Package that is dated June 2, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

To work around this problem, follow these steps:

1. Open your converted Access database in Access 2002.
2. On the Tools menu, point to Macro, and then click Visual Basic Editor.
3. In the Visual Basic Editor, click References on the Tools menu.
4. In the Available References list, click to select the Microsoft DAO 3.6 Object Library check box.
5. Click OK to close the References dialog box.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.