ODBC Timeout in RunSQL

[intersection row and column]

I ran a query in VBA Access with :
DoCmd.RunSQL strSQL
I got an error message, something like "ODBC Timeout ...".
How can I fix the problem ?
Thx

 

[GregB]

I ran a query in VBA Access with :
DoCmd.RunSQL strSQL
I got an error message, something like "ODBC Timeout ...".
How can I fix the problem ?
Thx

It could be the issue of an inefficient query. Did you try to use a
'Debug.Print' statement to isolate the query (and viewing it via the
immediate window) such as

Debug.Print strSQL

From there, put the query into the query editor and see if it runs
well or if it times out in that context also. Feel free to post the
query itself here as that can help folks help you.

Regards,
GB

 

[intersection row and column]

I ran the program a second time and this time there was no error message.
strange ...
Thanks for the tip anyway.