ADO Error

  • Thread starter Thread starter Chefjay22
  • Start date Start date
C

Chefjay22

I have a user that migrated from MS Access 2000 to 2003. When they launch
their database the get an error in their code:

Compile error:

Can't Find Project or Library

It appears there is a reference in the code rst As ADODB.Recordset. Do they
need to Install an ADO Add-in? If so, does anyone have a link to a download?
Am I on the right Track? Thanks!
 
I doubt any download is required.

Go into the VB Editor and select Tools | References from the menu.

Examine all of the selected references.

If any of the selected references (they'll all be at the top of the list)
have "MISSING:" in front of them, unselect them, and back out of the dialog.
(NOTE: write down what the references are before you delete them, because
they'll be in a different order when you go back in) If you really need the
reference(s) you just unselected (you can tell by doing a Compile, on the
Debug menu), go back in and reselect them.

If none have "MISSING:" (or if the step above doesn't solve the problem), go
back into the References and see whether one of the selected references is
Microsoft ActiveX Data Objects 2.x Library (where x can be any number
between 0 and 8). If not, scroll through the list until you find it and
select it. (Which version you select is really up to you.)
 
Back
Top