By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,889 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,889 IT Pros & Developers. It's quick & easy.

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

P: n/a

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!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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!

Nov 12 '05 #2

P: n/a
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!

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.