Access 2007 - Can't add reference to specified file?
I am trying to reference a DLL and any DLL I try it seems like this error occurs. I believe the DLL is already register as I get that loaded error on the regsvr32 of it. I am using Vista and Access 07. Any ideas all?
Is this an ActiveX DLL? If yes, you should be able to add it using, from VB, (Tools | References), [Browse] button. If not, you can perhaps simply declare the DLL functions, or you might need to load the DLL manually, using LoadLibrary in kernel32, before you can use them. A good example for that can be found here:
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
Stephan Lebans: MouseWheelOnOff (sample database with a DLL)
http://www.lebans.com/mousewheelonoff.htm
(°v°)