Access 2002 and ADO

[asnyder]

Whenever I try to use and ADO connection. For example if I say:

Dim cnn as ADODB.Connection
etc.
etc.

I receive the following message:

User-defined type not defined. Am I missing a reference or something. We just upgraded to access 2002 from 97.

 

[WayneRyan]

asnyder,

Yes you are missing a reference. Use the Search facility here
and look for references.

Wayne

 

[asnyder]

I've already tried that and I don't know which refernce is missing.

 

[WayneRyan]

asnyder,

Courtesy of DCX:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51946

Wayne

 

[dcx693]

Actually, that thread involves someone using Access 2000+ and trying to use DAO. In this case, the user is trying to use ADO and must be missing a reference to the "Microsoft ActiveX Data Object 2.x Library".

This typically happens when you move an Access 97 database to Access 2000+. It will have a reference to Microsoft DAO 3.x by default.

You might want to remove that reference to DAO. Best to stick with just one object library. Cuts down on the overhead.

 

[WayneRyan]

DCX,

Oops ...

You may also want to remove the reference to ActiveX Data Objects 2.x Library.

I read that line and just saw the library name, not the remove
part.

Wayne

 

[asnyder]

Thanks everyone. I got it working. It doesn't need the Microsoft DAO Library 3.5, but it won't work without the ActiveX Data Object 2.1 Library. I hope this helps someone else.