![]() ![]() ' authorize user access to the SQL Server. ' use Microsoft Windows NT Authentication Mode to ' Note: The DSN referenced below must be configured to Set qdfStores = dbsCurrent.CreateQueryDef("Stores", _ ' Change the default QueryTimeout of the Northwindĭebug.Print "Default QueryTimeout of Database: " & _ĭebug.Print "New QueryTimeout of Database: " & _ ![]() Set dbsCurrent = OpenDatabase("Northwind.mdb") This example uses the ODBCTimeout and QueryTimeout properties to show how the QueryTimeout setting on a Database object sets the default ODBCTimeout setting on any QueryDef objects created from the Database object. You can override this value for a specific query by setting the ODBCTimeout property of the particular QueryDef object. When you use QueryTimeout with a Connection or Database object, it specifies a global value for all queries associated with the database. Rather than waiting indefinitely, you can specify how long to wait. When you're using an ODBC database, such as Microsoft SQL Server, there may be delays due to network traffic or heavy use of the ODBC server. SyntaxĮxpression A variable that represents a Database object. Sets or returns a value that specifies the number of seconds to wait before a timeout error occurs when a query is executed on an ODBC data source. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |