Link to home
Start Free TrialLog in
Avatar of joylene6
joylene6Flag for United States of America

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
Avatar of HainKurt
HainKurt
Flag of Canada image

what is your query?
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?
Avatar of joylene6

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.
ASKER CERTIFIED SOLUTION
Avatar of HainKurt
HainKurt
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks I will ask her that
The error left when we limited the qry. Thanks