• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3085
  • Last Modified:

Microsoft Access Error in Loading DLL

Good day everyone
Just migrated to a new system, running Windows 7 Pro 64 bit and Office Professional Plus 2007. When trying to open up an Access Database that was written in Access 2003 I am confronted with an error in the Switch Board Form, "Compile Error: Error Loading DLL", see attached screen shots from the debugger console in Access.
I have looked at the MS KB site and the MSDN KBs area and manually regesitered 2 dlls that were referenced to no avail. The 2 dlls are: dao360.dll and msado15.dll. I have tried to do a convert and save as to Access 2007 format and the error still exists. The compile option in the debugger console is grayed out so I have not been able to re-compile this form in an attempt to correct the error. (that was suggested in one of the MS developers forums). I can open this database on a Windows 7 Pro 32 bit machine running the same version of Office.
Ideas?

Thank you in advance
AccessError1.JPG
AccessError2.JPG
0
Bob Conklin
Asked:
Bob Conklin
  • 5
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
My guess is that the Windows 7 install also installed higher versions of DAO and ADO on your box.  To verify, open your Access app, go into any code module, go into Tools:References, and see if t...
(1)  There are references to DAO and ADO with a prefix of 'MISSING: ', and
(2)  When you scroll down there are higher versions of DAO and ADO.

The most likely path to success is to uncheck the previous versions, check the new versions, then test your app to make sure it works as expected with the newer versions.

Another path, although less solid, is to grab those files off of someone else's box, put them on yours, register them manually, and see if your Access app works.

Hope this helps.
Jim
0
 
Bob ConklinConfiguration/TEST TechnicianAuthor Commented:
Will give it a try and let you know...
0
 
Bob ConklinConfiguration/TEST TechnicianAuthor Commented:
Hi Jim
I tried your suggestion and did not see any referances to "Missing" entries, the 2 dlls I manually registered were copied from a Windows 7 system that does open the database with out error.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jeffrey CoachmanMIS LiasonCommented:
Note that Some Access code needs to be modified to work in 64 bit environments.
Like this:
http://gpgonaccess.blogspot.com/2010/03/work-in-progress-and-64-bit-vba.html
0
 
Bob ConklinConfiguration/TEST TechnicianAuthor Commented:
Addendum to my earlier post about 32 bit versus 64 bit, using another 64 bit system that was built from a corporate image the database opens as expected. I am having an uneasy feeling that something might have not installed properly in the machine that refuses to open the database with out erroring out. The system in question was a "Clean load" as opposed to the image supplied to us. Clean meaning using the OEM install DVD from the manufacturer to load the OS and then using a MS factory install disc for Office.
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK

keep us posted
0
 
Bob ConklinConfiguration/TEST TechnicianAuthor Commented:
Ok here is the latest, I took the Office 2007 install disc, re-ran the installation procedure, went to MS Update, applied the updates once again and now the database opens normally. (hmmmm??!!)
0
 
Bob ConklinConfiguration/TEST TechnicianAuthor Commented:
Although thie final solution that corrected the issue, nothice I did not say fixed, was a re-install of the application suite, I still wonder what was at the bottom the pile so to speak.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now