Error: File not found VBA6.dll

[nkiefer]

I recently inherited an Access 97 db that when I open it and try to compile a module i receive this error message:

File not found: vba6.dll

I have been using this PC to develop other Access 97 apps and never ran across this. I have this file on my PC.

Where in the application can I look to see where this file is being used? The "Visual Basic for Applications" dll listed in the references is msvbvm60.dll

 

[hymn]

I would check the references of the db first and see if any are missing


Hope this helps
Hymn

 

[nkiefer]

No nothing is missing. I think the problem may be with the file that is referenced in the VBA program.

 

[CajunCenturion]

msvbvm60.dll is part of the run-time environment used by all VBA based applications.

VBA6.dll is part of the VBA Engine used by the MS Visual Studio (ie VB6), and Access should not be using that reference.

C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL is the correct "Visual Basic for Applications" reference for Access because it includes not only the basics, but part of the VBE (the editor).

I would uncheck the existing "Visual Basic for Applications" reference that uses VBA6.DLL, and then look at all of the other "Visual Basic for Applications" that are in the list - just click on the name, not the checkbox to see the actual file involved - and when you find the one listed above as the one for Access, then check it's checkbox.



Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[nkiefer]

When I try to uncheck the reference to "Visual Basic For Applications" I get the message: "You can't remove this reference" Microsoft Access needs this reference in order to work properly.

I decided to create a new blank database and import all of the objects from the original one. Now it seems to work and the VBA reference is pointing to VBA332.dll.

Apparently Access references the VBA DLL when it installs.

Thanks for all of your help.