problem with ADODB.Recorset

[carlosdsousa]

hi to all

I have a report that works fine in my laptop.
I imported the report to access aplication into the computer at work and returns error on:

- Set RsTabela = New ADODB.Recordset

he doesn´t recognize ADODB... DAO...

both have xp professional
office 2003
mdac 2.8..

i don´t now if some instalation is missing...

thanks for the time and replays

 

[IanH]

He probably doesn't have the necessary libraries installed / available.

On your PC open up the database and go into one of the modules. On the menu click on TOOLS ... REFERENCES and have a look to see which ones you have got a check mark against.

Then do the same on your colleagues PC and see which one is not checked. Scroll down the list and make sure that the same, or later versions of the libraries are checked. That should fix it.

As an example, on my (earlier) version of Access, I would have checks against the
Microsoft DAO 3.6 Object library and
Microsoft ActiveX Data Objects 2.6 library

But that is for Access 2000, so not sure what you have in your list for Access 2003.

Regards

Ian