MS Access 2000 ODBC User requested cancel

[MSIsam]

I am using MS Access to query an Oracle database using an ODBC connection. The query returns an error after 60 seconds that says that the user cancelled execution of the query. I am pretty sure that there is a ODBC timeout set to 60 seconds somewhere within Access but I cannot find out how to modify.

Any ideas would be greatly appreciated.

Thanks,
Sam

 

[PGoRule]

Check out the following links...
Access : How to Set the QueryTimeout Value for ODBC Connections
First Question - How do I change ODBC time-out in Microsoft Access?

Sharing the best from my side...

--Prashant--