Open the database you want to enter the query in, select the query you want to change the default timeout value for, and select Design View from drop down.This value can be changed through the following steps:
The Query Design Interface (View) in MS Access and SQL View in SQL Server contain few pre – built queries, with default timeout value as 60 seconds. There are three variants of queries that can be modified Pre-Existing Query Although both the applications greatly vary in their capacities to contain data, similar kind of procedure is used in both for modification of query timings. Many users of the applications are unaware of the possibility of modifying query timings in both the applications. Often while using queries in the MS Access application as well as SQL Server, there are instances when your query might time out, before you can get the query results.
In this article we look at changing the default timeout value placed in Ms Access for running queries
0 kommentar(er)
