new Access doesn't recognize ADODB.Recordset statement

[SashaBuilder3]

Hi everyone,


Here is a problem. I've started using a newly installed Office-2000 and my Access VBA gives me error messages if I try to use ADO components, for example, such a message comes for the following declaration line:

Dim rs As New ADODB.Recordset

It tells that this is a user defined data type or something like that. Interesting, that my db created on another machine with Windows-XP (with its Office) works on the new PC without problems (needless to say its programs use ADO stuff).

Can anyone tell me what's going on?


Thanks,

Alexandre

 

[PHV]

While in VBE, menu Tools -> References ...
Check Microsoft ActiveX Data Object 2.x Library

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SashaBuilder3]

PH,

Thanks a lot!

Alex