[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2722
  • 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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
Jeffrey CoachmanCommented:
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 CoachmanCommented:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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