Hello everyone.

I’m looking for some advice on the best way to automate a database to do two things.

1. A very quick repair, just to make sure everything is in line.
2. An automatic Compact and Repair.
3. Make backups within a created folder “example (My Documents)

Ultimately I would like it if I was able to find some code that would automatically find the database within list of databases, back it up in a folder I have assigned for it to be backed up in, Compacted and Repaired then the new Compacted, repaired and tweaked database would go back to the starting location.

If anyone has any advice or experience with this, I would be great full to hear from you

Thanks for your help

Corey

Where do you want to run this from? Most of it can be done from a script. I will have to look up the compact and repair. I usually set all my databases to compact on close, which keeps issues to a minimum.



mmcdonal

Here is a free utility that will do this for you.

Please note that it is USUALLY not necessary to repair a database unless it is in development. Once it goes into production, only compacting should be necessary.

Regardless, you can't really compact and repair a database in code if the database is 2000 or later. The datbase code and system information is stored in a BLOB instead of discrete records, as with earlier versions, so individuals items can't be rectified using DAO CompactDatabase, for example. Only the menu, switch (/Compact) or this utility (and others like it) will do the trick.

HTH

mmcdonal

Hehe, sorry: http://www.trigeminal.com/lang/1033/...asp?ItemID=2#2



mmcdonal

This is great information. Thanks Mmcdonal