Copying data from Access database while it is being used

R

Ritesh Paunikar

I have a Access database which is used by an application and is continously
storing data. The application which is storing data is running on different
machines and storing in different access databses. Is it possible to transfer
the data from these individual PC into a seperate database which the
application is using it? If yes, can anyone help me with this??

Is there a solution for this?

Regards,
Ritesh
 
A

Arvin Meyer

If you use an Append query to push the data into another database, it can be
done safely. You'll need to buy a book or use the helpfiles, because the
entire solution is a bit too complex to do more than outline here.
Essentially to run Tranactions with a Transaction the process succeeds or
you roll it back to where it was. A Transaction places the entire block of
data into another temporary table, often in memory for the smaller ones,
then committs it if there are no errors.

What will happen in your case is that the Transaction will lock the
table(s), then grab the data, then release the tables. If a table is already
locked, it will throw an error and fail. Your code should, allow for these
and try again at least a few times before informing the user that the
transaction has failed. The keywords you want to look for in help are:

Transaction, BeginTrans, CommitTrans, Rollback
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top