CODEWITHSUNDEEP
sql-serverdatabaseperformancems-accessbackground-process
Jason Steward
Jason Steward

Reputation: 39

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?

Upvotes: 1

Views: 1629

Answers (2)

Jason Steward
Jason Steward

Reputation: 39

Thanks, Gustav! I think I'll go ahead and execute a command as soon as my form loads to open a second instance of Access. This second instance will have an AutoExec macro to run my append and update queries then close that database. That should give me my background query. I just need to do a little research on how to trigger that second database to open. Thanks for the idea!

Upvotes: 0

Gustav
Gustav

Reputation: 55841

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

Upvotes: 2

Related Questions