In my Access application, a make table created executed and deleted when finished. At times runtime errors are displayed after the query has ran. How can I check for the query existance when the progrma runs?

Put this code before your problem code if you know the code is running okay and the errors are erroneous:

'--------
On Error Resume Next

'--------

HTH

mmcdonal

Sorry, I missed the last sentence. What do you mean you want to check for a query's existence?


mmcdonal

Thanks for the response.

My code creates a query on the fly. When the user is finished the query is deleted. It is ok as long as runtime errors do not show. The problem happen recently when the application is used in Access 2000. A runtime error 2486 "Access is busy". I usually kill Access by going to Task Manager. When running the application after killing it, the application never had chance to delete the query. I have found some code to check for the query, but it bombed when the query didnot exist. Here is the code:

If curdb.QueryDefs("qryCreate Current Date").Name = "qryCreate Current Date" Then
    DoCmd.DeleteObject acQuery, "qryCreate Current Date"
End If

Note: The application was created in Access 2003, but used by Access 2000 users.