Good morning Experts,
I have five pass-through queries that will create five tables for a total of about half a million records. This process is to audit a customers account and will need to be repeated on a daily basis to monitor account activity and track any changes.
The last time I did something like this I used make table queries to call the pass-through queries. The process took several hours to run.
I was wondering if instead of running make table queries every day I run them just once to create the tables in my Access database. Then each day run delete and append queries to update the account information.
Do you think this will help the overall process run faster?
I need the most efficient way to get all the data locally so a team can work the account. I am trying to cut down on the run time as much as possible.
Any other suggestions are greatly appreciated.