Compact/Repair & Backup

[mcongdon]

Hey guys,
I was wondering if there is a way to put a command on closing a database that would compact and repair it, create a dated backup file of itself, then close.
Any helpful hints on how to get started on this would be greatly appreciated.
Thanks!

 

[bubba100]

If your version is 2000 or newer I beleieve you have a setting to compact on close.

 

[missinglinq]

But you have the order reversed! Compact & Repair is said to be a common cause of corruption! You need to always do a backup then Compact & Repair!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[mcongdon]

Thanks for the tip on compacting! Any ideas on how to create a backup automatically? I know in Access 2003 and Access 2007 there are easy commands to do this, but in 2000 there isn't. Is there VBA code that will automatically create a copy of the whole database? I don't want end users manually copying and pasting the database in windows explorer!

 

[oharab]

Take a look at this. It produces text files for all the objects in your database (handy for solving corruption issues too).
All the source code is included, so you could integrate it into your app with a little fuss.

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.