<div>
What's changed in your environment? This usually indicates that an update or some other upgrade has either moved or overwritten DLLs on the offending machine. Have you opened the DB up and checked for any missing references? <br />
J
</div>


What's changed in your environment? This usually indicates that an update or some other upgrade has either moved or overwritten DLLs on the offending machine. Have you opened the DB up and checked for any missing references?
J

<div>
in case the References suggestions does not fix this ... can you post all the relevant code?<br />
<br />
mx
</div>


in case the References suggestions does not fix this ... can you post all the relevant code?

mx

<div>
Thanks! It was the references.
</div>


<div>
<div class="content wysiwyg-content">
I am getting the following Visual Basic error in an Access Database (mdb):<br />
<br />
Compile error:<br />
User-defined type not defined<br />
<br />
The variable that it doesn't recognize is &quot;New ADODB.Recordset&quot;<br />
<br />
This database has worked just fine without any issues. Now it doesn't recognize the ADODB variable types.
</div>
</div>


I am getting the following Visual Basic error in an Access Database (mdb):

Compile error:
User-defined type not defined

The variable that it doesn't recognize is "New ADODB.Recordset"

This database has worked just fine without any issues. Now it doesn't recognize the ADODB variable types.

Doesn't recognize the ADODB variable types

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.