L
lenny3k
Hi there
I have a MS Excel workbook that contains a VB Macro. The Macro uses Doa/ODBC to retrieve data from a SQL database.
Recently, I tried to use this macro on a machine with MSExcel 97 (had previously used later versions). However, I am getting errors all the time from a call to the "CreateWorkspace" function
Every time I call it, ther error "Could not load dll: ?????L? - 3633"
I have tried unsuccessfully to resolve this be reinstalling and reregistering as number of dlls (eg: MDAC 2.8) - but all to no avail
Anyone have any ideas what dll (if any) I shuold be looking for
The offending code is like this
Dim wsp As Workspac
Set wsp = CreateWorkspace("", "admin", "", dbUseODBC)
I'd appreciate any help!
Len
I have a MS Excel workbook that contains a VB Macro. The Macro uses Doa/ODBC to retrieve data from a SQL database.
Recently, I tried to use this macro on a machine with MSExcel 97 (had previously used later versions). However, I am getting errors all the time from a call to the "CreateWorkspace" function
Every time I call it, ther error "Could not load dll: ?????L? - 3633"
I have tried unsuccessfully to resolve this be reinstalling and reregistering as number of dlls (eg: MDAC 2.8) - but all to no avail
Anyone have any ideas what dll (if any) I shuold be looking for
The offending code is like this
Dim wsp As Workspac
Set wsp = CreateWorkspace("", "admin", "", dbUseODBC)
I'd appreciate any help!
Len