We help IT Professionals succeed at work.

DLL Hell?

TownTalk asked
Last Modified: 2012-05-11
I think this is a DLL problem, but i'm not sure.....

We have a mixture of XP and windows 7 pcs around the office. Normally I develop our application on a Windows XP machine and create a .ACCDE file for the clients to use.

Today I used a Windows 7 pc to create a .ACCDE what I found is that other Windows 7 clients can open this file without a problem. However, XP clients cannot now open the ACCDE or ACCDB. They get an error:

"Class does not support automation, or expected interface is missing" This error occurs at a line in my code where an ADODB.connection is declared.

I am surprised that the .ACCDB also now exhibits this behaviour on my original pc. What might have caused this? I have checked that I have no missing references. Everything looks ok there.
Watch Question

Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Unlock this solution and get a sample of our free trial.
(No credit card required)


Yes this is new Windows 7 machine that we only bought last week. I installed all the updates, including Service Pack 1. Since I posted my original question, I dug out a backup copy of the .ACCDB and verified that the references hadn't changed.

So I think you are correct. So I will avoid using this machine for development until I hear that this has been fixed.

Thanks for your help.

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.