Microsoft KB Archive/843189

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

Article ID: 843189

Article Last Modified on 4/7/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-





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.



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 &quot;Applies to&quot; section.

Additional query words: acc2002 connectivity

Keywords: kberrmsg kbbug kbfix kbqfe kbconversion kbhotfixserver kbofficexppostsp3fix KB843189

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.