Microsoft Access Automated Compact and Repair Tool With Nightly Or Weekly Event

Do you want to make sure that your databases are properly compacted and repaired on a regular basis? Hi, this is Richard Rost with Access Learning Zone. I just released my new Access Compactor template. This is itself a standalone Access database that you can either incorporate into your existing database projects, or you can run it as a standalone.

I like to run it once a week to compact all of my backend database files. I've got a lot of them. You just put this guy in your nightly event or your weekly event or whatever you've got, and I'll show you how to set one of those up when you purchase the template. The Compactor will back up your files first if you want.

It will compact and repair them your databases, create a log file, and then it will exit and relaunch your original database, if you've got a database that runs constantly. The Compactor is pretty straightforward to use. You pick your database folder. In my case, I've got my database temporary folder set up here in My Database.

I've got my front-end file, and then four backend files. There's an option to have this auto start, so when this database runs, it automatically begins the compact. Do that if you're going to be including this in some kind of a nightly or weekly backup, the Compactor can back up the backend files before it actually compacts them, which is a good.

You can have Compactor close when it's done, which means when the Compactor is done with its job, it'll just shut down. You can have it right out of text log so you can check that and make sure everything's working okay, and you can have it optionally relaunch your database if you're going to close your original database so the compactor can compact it too.

Then you can have it relaunch your original database. And of course, you can always run the job manually by clicking on Perform Compact. It will then re-launch your front-end database. It will then create a compact log. It notes everything that it backed up and how much space you saved. These files have already been through this compactor about 10 times. So they, they didn't compact anymore. The backups will be automatically named for you based on the date that they were compacted and backed up.

And that's it, that's the Access Compactor. Very simple utility. It's an Access database, so there's no other components to install. Like I said, just run it as part of your nightly or your weekly backup routine, and it'll make sure all your backend databases stay nice and compact. If you got any questions, contact me or post 'em down below.

KEYWORDS
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #template, Access Database Compact Tool, Automated Compact and Repair of Access, Automatically Compact and Repair, nightly event, weekly event

[Shadow.Dragon]

LOL!!! You must have been reading my mind! I was going to ask if MSAccess had some type of auto-backup function. 🙂