ODBC Call Failed

Connectivity
Enthusiast

ODBC Call Failed

I am trying to run my query after my linked table in Access 2007 is done and all is fine. I get an ODBC call failed periodically. It normally happens during business hours. On the weekends, early morning, it is fine. Others on my team sometimes get it and sometimes they don't. Others on my team can run the query in like 2 minutes and others 45, then others half an hour and then others get the ODBC call failed. Is this because there is a lot of traffic on the server we are connecting to and IP, VPN issues?