How best to backup an Access database

  • Thread starter Thread starter MikeB
  • Start date Start date
M

MikeB

OK, reading here I saw someone has lost his database and there was
talk about backup. What I'm doing for backup is ever so often, I copy/
paste a copy of my .mdb file. I have automatic backup software that
then backs that up offsite.

Should I create something that exports the data in the tables and use
that as a backup or am I doing enough?

What so people do to backup their access applications?
 
On Wed, 23 Jan 2008 18:32:36 -0800 (PST), MikeB <[email protected]>
wrote:

Per best practices you have a split database, with a front-end (most
likely MDE) on each workstattion, and a back-end MDB with the tables
on the server.
Backup the MDB every night. Backup the MDB that created the MDE for
every version.
Look into grandfather - father - son backup schemes for more robust
backups.

-Tom.
 
Copying the ACCESS database file and putting the copy in a safe place is how
to backup your database's data.
 
je ne lis pas l'anglais
Tom van Stiphout said:
Per best practices you have a split database, with a front-end (most
likely MDE) on each workstattion, and a back-end MDB with the tables
on the server.
Backup the MDB every night. Backup the MDB that created the MDE for
every version.
Look into grandfather - father - son backup schemes for more robust
backups.

-Tom.
Click to expand...
 
Back
Top