I have an Access 2000 database with a MS SQL 2005 back end. I'm running queries that are timming out as the database grows. We have a long term solution but I need something to get them up and running now.
How do I increase the timeout to run the query on the code below?
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
SQL = "Select * from MyTable"
rs.Open SQL, CurrentProject.Connection