Compile error- 'Error in loading dll' (Access 2002)

[Mudface]

When attempting to run (or even just compile) the following code, I get the .Connection object of the CurrentProject highlighted along with a message box saying 'Error in loading dll'.

Public Sub Test()
Dim cat As ADOX.Catalog

Set cat = New ADOX.Catalog

cat.ActiveConnection = CurrentProject.Connection

End Sub

I've checked my references, and there's nothing highlighted as missing, but I've noticed that when I create a new database, I often get the message 'Object Library not registered' when first creating a new object in the database (Table, Module etc). Is this a case for a reinstallation, or is there another fix (I've tried re-registering some of the dll's but the problem has persisted). Cheers for any help.

 

[dk]

Hello mate,

It's a long shot but have you tried running Detect and Repair from the help menu? If that doesn't work then you could try reinstalling the latest version of MDAC from here. Amongst other things this will install the ADO and ADOX libraries and associated DLLs.

Good luck. Fixing problems with these libraries as well as the Jet components is a pain in the **** - I've wasted hours of beer drinking time downloading, reinstalling, rebooting, downloading again......

 

[Mudface]

Hi, Dan. Unfortunately, the Detect and Repair didn't .

I got the MDAC component checker from the link you provided however, and there were quite a few missing registry entries for ADOX. Naturally, our Network Admin guy isn't around at the minute and even more obviously I don't have admin rights on my PC so I can't install the latest components... Cheers for your help, though, I'll repost when I can get the new components installed.

 

[Mudface]

Yay, reinstalling the MDAC worked . Cheers, Dan, I owe you one