Backup Table Data

[Donna]

I use Access 2000 to record my husband's live auction
sales on a 3-station network. The "clerking table" is
where all sales are recorded as they happen and this data
is crucial to the auction.

Does anyone have any idea of how I can make a backup of
this table simultaneously as data is being recorded in it??

Any help will be appreciated.

 

[GPO]

First of all, backing up is not Access/Jet's strong point. If you have
mission critical data (i.e. lots of money riding on it) it might pay to
invest in a proper client server database design, particularly if you need a
"live" backup.

Another alternative is to investigate a RAID solution, this is a way of
writing to two disks simultaneously. If one disk fails, you still have your
data on the other one. If both fail (fire, bomb, flood) you're up Scheizen
Creek. You don't do RAID through Access. You need the right hardware.
Thankfully it is becoming very common for new motherboards to have RAID
capacity built in.

Anyway...

Are you recording data through a form or (cringe) directly into the table?
If you are using a form, you could have a "save" command button that writes
the data to your "clerking" table, and also to an identical table stored in
say another access database on a different drive and linked to your db (see
linked table manager). You could periodically run a query to compare the two
tables to make sure they are in sync.