Hi All,
I have a problem with a routine that works on one computer running Office 2000, but not on another.
I have an add-in that runs from Excel and reformats a spreadsheet. Once this is completed, then this data is appended to a table in an Access database. Everything runs fine on our laptop, but there is a problem getting it to work on the client's machine. The problem occurs when it tries to run the sub routine that connects to the database.
I am acting as a middleman on this issue, as the problem is occuring overseas and is trying to be solved by someone else. This is their description of the problem:
"No luck with the macro. It still fails, despite upgrading the installation to SP2 of Office 2000, which is the same as mine.
It crashes when trying to connect to the specified database, wherever that is. The error message received is:
Runtime error '-2147220999 (800401f9)'
Method 'Open' of object '_Connection' failed
The number in brackets is hex code for an error that says "Error in the DLL" according to Knowledgebase.
We found one DLL that office setup was unable to repair, that was an earlier version than mine - VGX.DLL
I replaced that but the problem continues."
Does anyone have any experience with a similar sort of problem and solutions on how to solve it?
All help much appreciated.
Cheers,