Adjust Query Timeout on MS Access for NetSuite ODBC Connection

 

1. In Microsoft Access, open the Access database and right click the query (Example: Employee Sales by Country). Click Design View in the drop down menu.
2. In the Design View window, click View icon in top left corner. And then select SQL View in the drop down.
3. When the SQL View is opened, click View in the menu bar at the top. And then select Properties.
4. In the ODBC Timeout field, type in a new value.
5. Close the window and save the query.

When a query is run on an Open Database Connectivity (ODBC) database, use the ODBCTimeout property to specify the number of seconds Microsoft Access waits before a time-out error occurs. By setting this property to zero (0), no time-out should occur. For example, 120 will make this query timeout after 120 seconds even if the query has not been completed.