I guess that u are using ado.
I also guess that you put your SQL statement to be executed in a command object.
To return immediately to your app after executing a SQL statement is to use the adAsyncExecute option:

Set adoRecord = adoCommand.Execute(, , adAsyncExecute)