BackUp

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

Is there anywhere to get Access to BackUp a certain Table to a different
computer on a network every 5 minutes without interupting the users that
are currently using the system, sort of a seamless backup?
Thanks
DS
 
Every 5 minutes? Whew.

Alternatives:
a) If this is so the 2nd computer can have live data, you could just split
the database and share the back end.

b) If this is to create a secure copy, you could use the Timer event of a
(hidden) form to execute a query that either appends the new records or
re-creates the table. If you create a new query, and choose Make Table
(Query menu), you can specify the database name where you want to create
this.

c) Another alternative would be to use replication.

d) If you have multiple related tables that you need to update, take a look
at the code in this link:
http://allenbrowne.com/unlinked/Backup.txt

However, you do it, you are likely to strike concurrency issues trying to
copy out the data that is currently being manipulated.
 
Allen said:
Every 5 minutes? Whew.

Alternatives:
a) If this is so the 2nd computer can have live data, you could just split
the database and share the back end.

b) If this is to create a secure copy, you could use the Timer event of a
(hidden) form to execute a query that either appends the new records or
re-creates the table. If you create a new query, and choose Make Table
(Query menu), you can specify the database name where you want to create
this.

c) Another alternative would be to use replication.

d) If you have multiple related tables that you need to update, take a look
at the code in this link:
http://allenbrowne.com/unlinked/Backup.txt

However, you do it, you are likely to strike concurrency issues trying to
copy out the data that is currently being manipulated.
Click to expand...
The Reason is to have a most recent copy of the sales and SalesDetails
Table in case the system goes down. This way the user can pickup almost
where they left off. Perhaps a multi-layered type of back-up where only
records that have a time imprint of say later than 3 minutes ago get
backed up to Table A and then after 5 minutes they go to TABLE B...
Thanks
DS
 
If that's the case, I would be inclinded to recommend that as the
records are added to the table that you update a text file with the new
information. Basically in the Form's AfterInsert event you would grab
the values of the controls and write them to the text file. Shouldn't be
that difficult, but I don't have any code examples handy at the moment.
 
Back
Top