ADODB

[Terry D]

I was working in Access 2000 and using the following code to reference tables
and queries in my VBA application:

Dim rst1 As New ADODB.Recordset

I recently upgraded to Access 2003, and now VBA doesn't recognize that code.
I think I'm supposed to go to Tools, References in VBA, but I have no idea
which file I need to select. A heads-up on which file to select would be
great.

Thanks.

 

[Douglas J. Steele]

Microsoft ActiveX Data Object 2.x Library.

However, that reference should be set by default in Access 2003. Take a look
at your references to see whether any of them have MISSING: in front of
them.