Search code examples
sql-serverdatabaseperformancems-accessbackground-process

Is there a way to run a MS Access query in the background?

I have form linked to several offsite SQL server tables. When the form is closed, an event is triggered to run some update queries that copy large amounts of data from one table to another. While this is running, I lose control of Access functions. This can take a minute or so since my internet connection is slow. Is there a way to trigger those update queries to run in the background rather than shutting everything in Access down till that close event completely executes?

Solution

  • Short answer is No. Access is single-threaded.

    Your only option is to run a second instance of Access, and then push commands to this to carry out such background tasks.

    Edit:

    You can find a method to implement this setup while distributing frontends in my article:

    Deploy and update a Microsoft Access application in a Citrix environment