ODBC - call failed

[Guest]

Thank you for your help in advance.

In Access, I am using linked tables for my queries.
Whenever I open SOME linked tables, I got error messages like this: ODBC -
call failed.
1. I double checked my connection to ODBC and it is always successful in
Data Sources(ODBC) Connection Tab.
2. My queries are working good in another computer system.

Any sugestion and solution wold be really appreciated.
Thank you.

 

[David Lloyd]

Jay:

It would be helpful to know what version of Access you are using. Also what
database your linked tables are from and whether the error occurs when
opening the linked tables, the queries associated with the linked tables, or
both.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Thank you for your help in advance.

In Access, I am using linked tables for my queries.
Whenever I open SOME linked tables, I got error messages like this: ODBC -
call failed.
1. I double checked my connection to ODBC and it is always successful in
Data Sources(ODBC) Connection Tab.
2. My queries are working good in another computer system.

Any sugestion and solution wold be really appreciated.
Thank you.

 

[Guest]

You can amend the timeout value from 60 to maybe 360, how many records doe
the query normally produce..

Regards

Kev