I have this code in a module that keeps timeing out after 60 seconds is there a way to make it run for at least 10 minutes.
Dim db As Database
Dim strSQL As String
Set db = CurrentDb
strSQL = "INSERT INTO Daily_Trends_All SELECT Master.* FROM Master WHERE (((Master.filtered)=0) AND ((Master.biz_date)=#" & strDate & "#));"
db.QueryTimeout = 0
db.Execute (strSQL)
Thank you,
nilesh
Dim db As Database
Dim strSQL As String
Set db = CurrentDb
strSQL = "INSERT INTO Daily_Trends_All SELECT Master.* FROM Master WHERE (((Master.filtered)=0) AND ((Master.biz_date)=#" & strDate & "#));"
db.QueryTimeout = 0
db.Execute (strSQL)
Thank you,
nilesh