Reference Libraries Disappear at Startup

[jjobrien03]

I have to enable the following reference library to execute SQL commands in VBA. While I have added my UDF into my startup workbook, the reference library becomes unchecked every time I open and close Excel? How do I get it to stay added whenever I open my startup workbook?

Libary: Microsoft ActiveX Data Objects 2.8 Library

 

[pbornemeier]

I have not experienced that. Perhaps one of the following will help:

Could be a versioning issue. This (somewhat old) post has an interesting discussion:

Google Groups

Google Groups allows you to create and participate in online forums and email-based groups with a rich experience for community conversations.

groups.google.com

This post discusses how to check if a dll is registered in windows:

How do I know if a DLL is registered?

When you are registering a DLL in old machines (Windows XP), regsrv always says that the registration was sucessful. This happens even if the user doesn't have permission to register. With the nam...

serverfault.com

You could also use late binding so the reference did not have to be set prior to running the code.