ODBC Timeout???

[DaddyNackers]

I am getting an "ODBC - called failed" error when trying to run a complicated query using ODBC linked tables. I found that if I change the property of the ODBC Timeout to 0, the query will run.

However, I have code which runs each query rather than manually running each query. Is there a way to change the default in MS Access for the ODBC Timeout from 60 to 0, so I don't have to do this manually.

I appreciate any and all help. Oh, BTW, I have cookies for anyone that helps me.

Thanks,
Nackers

 

[vb5prgrmr]

I believe options...

Good Luck

 

[ETID]

can you post the first few lines of your query code?