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.