SQL ODBC timeout in RunSQL - TechRepublic
General discussion
May 1, 2003 at 07:39 AM
john_wills

SQL ODBC timeout in RunSQL

by john_wills . Updated 23 years, 2 months ago

I have in an Access database a query object reading from a remote database via ODBC. It takes a while, but it works. To let the user set criteria I have the same query in VBA executed from a form via DoCmd.RunSQL. I get an ODBC Timeout message. I know how to change the timeout value in a query object, but not in a text query within VBA. How can I set my timeout value, and is there anything else I can do?

This discussion is locked

All Comments