joylene6
asked on
ODBC failure when running MSACCESS query a second time.
Hello-
Have a MSACCESS issue that has been occurring frequently. It is running on Citrix.
Here is the problem, a query will run . Then when try to run again will get ODBC call failed
When try to re link the tables, unable. Need to exit out of database to relink.
ODBC-error.png
Have a MSACCESS issue that has been occurring frequently. It is running on Citrix.
Here is the problem, a query will run . Then when try to run again will get ODBC call failed
When try to re link the tables, unable. Need to exit out of database to relink.
ODBC-error.png
ASKER
I am working with a co-worker on this, Query with her.
She said the only difference was having access pick 5 records instead of All. The query do come back correct every time.
Not sure what you mean by connecting and closing the connection.
She said the only difference was having access pick 5 records instead of All. The query do come back correct every time.
Not sure what you mean by connecting and closing the connection.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks I will ask her that
ASKER
The error left when we limited the qry. Thanks
are you getting whole result when you run 1st time?
what is happening when you wait some time after 1st run and then 2nd run?
are you getting the error after immediately running the 1st?
are you connecting/closing connection?