Compile error: Can't find catalog - But the reference isn't missing!

[Kathy]

Hi All,
I have several users who are getting a compile error "Can't find project
or library when the code hits
Dim cat as ADOX.Catalog

In the references dialog box it show the msadox.dll as missing BUT it's
in it's folder right where it belongs. I'v tried decompiling the
database using the switch to no avail. The database runs fine on my
machine. No one had any problems with it yesterday and nothing has
changed.

I could really use a suggestion!
Thanks,
Kathy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Wayne Morgan]

You will find a good description here on handling reference problems. If you
create a new database does this reference still show Missing? If not, then
try to import everything into the new file. If it does, you may need to try
registering the dll. To do that, open a command prompt window and type

regsvr32 "path\file.dll"

http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Wayne Morgan
Microsoft Access MVP
"Kathy" <Kathy.merecat.com> wrote in message
news:40***********************@news.frii.net...

Hi All,
I have several users who are getting a compile error "Can't find project
or library when the code hits
Dim cat as ADOX.Catalog

In the references dialog box it show the msadox.dll as missing BUT it's
in it's folder right where it belongs. I'v tried decompiling the
database using the switch to no avail. The database runs fine on my
machine. No one had any problems with it yesterday and nothing has
changed.

I could really use a suggestion!
Thanks,
Kathy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Terry Kreft]

If the files in place then it probably isn't registered.

Use regsvr32 to register the dll using the following format

regsvr32 "C:\Program Files\Common Files\System\ado\msadox.dll"

Obvously you may need to change the path to msadox.dll and you may have to
put the full path to regsvr32.

Terry
"Kathy" <Kathy.merecat.com> wrote in message
news:40***********************@news.frii.net...

Hi All,
I have several users who are getting a compile error "Can't find project
or library when the code hits
Dim cat as ADOX.Catalog

In the references dialog box it show the msadox.dll as missing BUT it's
in it's folder right where it belongs. I'v tried decompiling the
database using the switch to no avail. The database runs fine on my
machine. No one had any problems with it yesterday and nothing has
changed.

I could really use a suggestion!
Thanks,
Kathy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!