How to Dim the existing connection

[muppetmad]

In access 2000 I used the statement Dim conn as ADODB.Connection. In Access 2003 I get a ACompile Error: "User-defined type not defined." How do I correct the problem?

 

[boblarson]

Add a reference to Microsoft ActiveX Data Objects in your references. Apparently you either have Access 97 or 2003, (Maybe 2007) which have DAO as the default and ADO not checked.

 

[muppetmad]

Yes, the program is in was 2000 and is now 2003. How do I add the reference?

 

[boblarson]

1. open a form in design mode
2. go to View > Code
3. once in the code window, go to Tools > Reference
4. scroll down to Microsoft ActiveX Data Objects 2.x (whatever the latest on your machine)
5. check the box next to it and close the window.