Back Ups

[Paul Martin]

Is there away to make and MDB database back up to a back up file as the main
file is closed?

I have just had a problem with my customer database corrupting whilst in
use, closing itself and then refusing to open. I have sorted it out on this
occasion but its made me realise not having a backup is risky and i'll never
remember to do it unless it does it for me.

Gratefull for your suggestions

Paul Martin

 

[Guest]

Hi Paul,

Your best idea is to have the file backed up as part of your regular network
backup strategy.

Damian.

 

[John Vinson]

Is there away to make and MDB database back up to a back up file as the main
file is closed?

I have just had a problem with my customer database corrupting whilst in
use, closing itself and then refusing to open. I have sorted it out on this
occasion but its made me realise not having a backup is risky and i'll never
remember to do it unless it does it for me.

Gratefull for your suggestions

Paul Martin

It's best to have Access databases backed up while they are CLOSED.

You can use Windows Scheduler to back it up; or use an online backup
service such as Carbonite (www.carbonite.com); or manually back the
..mdb/.mde file up onto a CD or DVD or external hard disk.

John W. Vinson[MVP]

 

[Bob W]

I suspect that you havee not split the tables from the procedures. If you
split the tables to a different mdb file and then link to them you avoid
corruption opf the tables. A simple copy of the procedure .mdb file can be
recovered any time without overwriting recent data.- bob