We have had some corp work done on our Remedy Database system and I now have a problem:
- I query to separate tables in the Remedy Database via MS Access.
- The two queries are both contain inside the same MS Access database file.
- They both use the same ODBC connection set up in the local machine.
- one query runs AOK, the other gets the following error:
ODBC -- Call Fail
[ISAM] No Data Found (#10001)
- I know there is data in the table, I'm able to run an ADO query via Vbasic calls, just can't do it from within MS Access, using exact same SQL statement etc.
- I'm not the only person 3 others have the same problem on 3 different machines.
any ideas thnx ... gba
- I query to separate tables in the Remedy Database via MS Access.
- The two queries are both contain inside the same MS Access database file.
- They both use the same ODBC connection set up in the local machine.
- one query runs AOK, the other gets the following error:
ODBC -- Call Fail
[ISAM] No Data Found (#10001)
- I know there is data in the table, I'm able to run an ADO query via Vbasic calls, just can't do it from within MS Access, using exact same SQL statement etc.
- I'm not the only person 3 others have the same problem on 3 different machines.
any ideas thnx ... gba
