How best to backup an Access database

[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?

 

[Tom van Stiphout]

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.

 

[Ken Snell \(MVP\)]

Copying the ACCESS database file and putting the copy in a safe place is how
to backup your database's data.

 

[azzedine]

je ne lis pas l'anglais

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.