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


The information in this article applies to:

  • Microsoft Access 2002

SYMPTOMS

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:
Compile error: User-defined type not defined

CAUSE

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.

RESOLUTION

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:

842780 Description of the Access 2002 post-Service Pack 3 hotfix package: June 2, 2004

WORKAROUND

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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MinorLast Reviewed:4/7/2006
Keywords:kbOfficeXPpostSP3fix kberrmsg kbconversion kbfix kbbug kbQFE KB843189 kbAudEndUser kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.