How do I change Odbc time-out in Microsoft Access?
Microsoft Access defaults to waiting for 60 seconds for ODBC calls to complete. Our experience suggests that most of the queries run against the warehouse, regardless of database, usually take longer than 60 seconds. This could account for your ODBC time-out errors. Access allows you to change this setting while in the query design screen for the current query only. To do this: • Using the mouse, move your cursor to the section of the screen which displays the tables you want to query (the upper portion of the screen). • Click the Right mouse button • In the window titled Query Properties, you should see a menu with one of the selections being Properties. • Select Properties. • You should see another screen which shows the ODBC time-out value of 60 along with some other information. • Change the ODBC time-out value to 0 (zero). • Close the window by clicking on the X in the upper right hand corner of the window. An alternative method of accessing the Query Properties window is as follo
