Venki

Do you run the query as a query in Access?

In design view you have Query Properties there you can adjust the

ODBC Timeout. Default is 60 s. I run into the same problem as you describe

and fixed it.

I usually run the queries with VBA code and ADO and the timeout property can then

be set (connection and command) timeout.

/Gosta