How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have a created a passthrough query that creates a result

Customer Question

Good Morning!
I have a created a passthrough query that creates a result table in MS Access. This process is repeated on independent MS Access db to unique source db2 environments.
The goal is to start all runs to retrieve the data. If each run takes 2 minutes to run, running in parallel on 20 sources could save 38 minutes!
The process are started from a .cmd file:
start db1.accdb /x macro1
start db2.accdb /x macro2
.
.
.
start db20.accdb /x macro20
At first I thought success was achieved. The processes all started and stopped gracefully. For verification, a timestamp column was added to the result set. The result was that some of the processes were not updated and there was no indication of an issue.
The only solution was to run the processes serially with each run kicking off the next one.
Please tell me there are some options to get access to run concurrently in this configuration.
Doran
Submitted: 3 months ago.
Category: Microsoft Office
Expert:  Kevin T replied 3 months ago.

Hi,
My name is ***** ***** I will be helping you.