Access Batch Update

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have an Access application with the back-end database located on the
server. The back-end database is shared by up to five client Access
applications. The application is design to track the Inventory. During the
day the data entry persons (they all have their own event to enter, one do
sales and the other do the purchase etc.) enter the sales, move or other
activities to the system, then before they go home at the end of the day,
they will update those events to the master Inventory table almost the same
time. I am talking about updating hundreds of events from each of the client
machine to the Access back-end. The update process is not a straight forward
procedure and it involves several SQL queries. The problem is some data got
corrupted and sometimes the number just don't add up. I wonder if there is a
way in Access to do a batch update and the system can arrange the update in
sequence regardless how many update requests from the client applications.
So that the back-end database will only do one update from a client
application at a time.
 
Paul

Maybe this will work, have a separate front end which will open then run
your SQL etc then close. This front end could be scheduled to run after
hours.

I tried this on my standalone using a front end and back end using Task
Scheduler and it worked, but using a server may require coding to run the
database.
 
Back
Top