Transfer Data from backend as a Backup

  • Thread starter Thread starter scott04
  • Start date Start date
S

scott04

Hi everyone,
I have a split database that is used across several locations. I am not
quite sure the system or methods to use to systematically backup the data
daily (in the event of crash/disaster ect). Can anyone offer me suggestions?
 
Hi everyone,
I have a split database that is used across several locations. I am not
quite sure the system or methods to use to systematically backup the data
daily (in the event of crash/disaster ect). Can anyone offer me suggestions?
Click to expand...

You only need to back up the backend (that's where the data resides, after
all) and a master copy of the frontend (so if everyone's computer burns up in
the fire you can get the CD out of the bank vault and rebuild).

The entire backend .mdb file should be backed up, at a time when nobody is
using the database. You'll do this outside of Access, using Windows or
(better) a third party backup utility.


John W. Vinson [MVP]
 
John,
Thanks for the info...any software that you might suggest? I did see
software that enables a copying even with users logged into the system. I
guess the only other option other than software is to manually do it a
particular time in the day when no users are logged on?
Scott
 
John,
Thanks for the info...any software that you might suggest? I did see
software that enables a copying even with users logged into the system. I
guess the only other option other than software is to manually do it a
particular time in the day when no users are logged on?
Scott
Click to expand...

Certainly not. That's cheapest to buy (most expensive to run if you value your
time at all of course). But you can use Windows Scheduler to copy the .mdb
file at 2:30am or some other such time. Or you can use a web-based backup
system such as Carbonite (www.carbonite.com) - there are quite a few such
services.

See Tony's website http://www.granite.ab.ca/tips/backups.htm for some general
backup principles that everyone would do well to follow... and that very few
folks actually DO follow (me included!!!)

John W. Vinson [MVP]
 
Back
Top