ACC2000: "User-defined Type Not Defined" Error Message

When you compile or run code, you may receive the following error message:

You are referring to an object in an object library that you do not have referenced.

You must add a reference to the object library that contains the object that you are using in code. To do so, follow these steps:

1. Open any module in the database that is generating the error described in the "Symptoms" section of this article.
2. On the Debug menu, click Compile <database name>. Note the line of code that is highlighted when you receive the error message.
3. On the Tools menu, click References.
4. Click to select the object library that contains the object referenced by the line of code that is highlighted.

NOTE: This section references Microsoft DAO. DAO is not used in Microsoft Access projects (*.adp), but the same concepts regarding missing object libraries apply.

Not having a reference to the Microsoft DAO Object Library is one of the most common reasons for the error described in the "Symptoms" section in Access databases (*.mdb). If the reference is missing, you may receive this error on many common DAO commands such as: If you receive this error on a common DAO object, you need to add the following reference:

Explicitly Declaring DAO and ADO Objects

A common reference conflict occurs when you have references to both the Microsoft DAO Object Library (DAO) and the Microsoft ActiveX Data Objects Library (ADO). This is because these two libraries contain objects with the same name, such as Recordset. To avoid any compile errors in the case where you add another object library reference that uses the same object names, it is good practice to include "DAO." in the declaration of any DAO objects. Likewise, when declaring ADO objects, include "ADODB." in the declaration. This is illustrated below using the Recordset object as an example:

Steps to Reproduce Behavior

1. Create a module and type the following procedure:

   Function Test()
      Dim db as DAO.Database
   End Function
   					

2. On the Tools menu, click to clear the Microsoft DAO Object Library check box.
3. To test this function, type the following line in the Immediate window, and then press ENTER:

   ?Test()
   						

   Note that you receive the error message mentioned in the "Symptoms" section.

For more information about ActiveX Data Objects (ADO), in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type ActiveX Data Objects in the Office Assistant or the Answer Wizard, and then click Search to view the topic.