SlinkyGirl
New Member
- Joined
- Aug 16, 2004
- Messages
- 11
Hi there.
I have a MS Excel workbook that contains a VB Macro. The Macro uses DAO/ODBC to retrieve data from a SQL database.
I can run the program some machines.
Some that it works on are win2000 with office 97 and XP Pro with office xp
but this is not a standard , cause it crashes with the following error on a machine running the sames as above.
I am gettign the error from the "CreateWorkspace" function.
This is the error:
Run-time error '3633':
Cannot load DLL: '?????L?'
I have tried unsuccessfully to resolve this by reinstalling and reregistering a number of dlls (eg: MDAC 2.8) - but all to no avail.
Anyone have any ideas what dll (if any) I should be looking for?
The offending code is like this:
Dim wsp As Workspace
Set wsp = CreateWorkspace("", "", "", dbUseODBC)
I'd appreciate any help!!
Thanks
I have a MS Excel workbook that contains a VB Macro. The Macro uses DAO/ODBC to retrieve data from a SQL database.
I can run the program some machines.
Some that it works on are win2000 with office 97 and XP Pro with office xp
but this is not a standard , cause it crashes with the following error on a machine running the sames as above.
I am gettign the error from the "CreateWorkspace" function.
This is the error:
Run-time error '3633':
Cannot load DLL: '?????L?'
I have tried unsuccessfully to resolve this by reinstalling and reregistering a number of dlls (eg: MDAC 2.8) - but all to no avail.
Anyone have any ideas what dll (if any) I should be looking for?
The offending code is like this:
Dim wsp As Workspace
Set wsp = CreateWorkspace("", "", "", dbUseODBC)
I'd appreciate any help!!
Thanks