Jenniferlynn
Technical User
Hi,
I am having a bit of a problem with Access ODBC. I'm a bit of a novice with this, so please excuse me if I sound dim!
Basically I run a query from Access, that pulls information from an internal database and then pulls this information back into Access. I am using Windows XP and the file format is Access 2000.
Thia was running fine, but I have recently been given a new computer and this Access database was transferred onto my new machine. Everything is in place as before.
Now when I try to run a query, I get the following error message:
"ODBC --call failed"
I have checked timeout settings and have also installed every version of Jet that I can get my hands on including SP7 and SP8 and installed MDAC 2.7 and 2.8 !
Does anyone have any ideas what the problem might be?
Any help would be greatly appreciated
I am having a bit of a problem with Access ODBC. I'm a bit of a novice with this, so please excuse me if I sound dim!
Basically I run a query from Access, that pulls information from an internal database and then pulls this information back into Access. I am using Windows XP and the file format is Access 2000.
Thia was running fine, but I have recently been given a new computer and this Access database was transferred onto my new machine. Everything is in place as before.
Now when I try to run a query, I get the following error message:
"ODBC --call failed"
I have checked timeout settings and have also installed every version of Jet that I can get my hands on including SP7 and SP8 and installed MDAC 2.7 and 2.8 !
Does anyone have any ideas what the problem might be?
Any help would be greatly appreciated