Hi, I have an excel 2007 file which is querying an Access 2002 database on a network using VBA and ADODB.Connection. It is working fine for all users (hundreds) however is falling down for one person. What could be different about this users setup which prevents the VBA querying the access database succesfuly.
Kind regards
Lee
You checked the references (VBEditor/Extra/references ) ?
Yes, references seem to be carried over to all users i.e. if I reference to something then this is the same for all users.
I don't think you got what I mean. You'll have to check on the local computer if the DLL's for ActiveX Data Objects are available and activated.
Maybe that I dont understand however I have checked in VB>Tools>References to ensure that ActiveX 2.8 libraries are showing a tick - do you mean that the actuall DLL file may be missing from local machine?
Yes you'll have to check on the local machine.
It might also help if you gave a bit more info than "falling down". I assume they are getting an error, but what and where?
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks