Hi,
I am looking for a utility that does the auto compact and repair that
works in the background as a service. It should keep logs of the procedure done and should allow database with passwords.
Thanks.

Surajguru,
Have you checked the compact/repair function help in VBA? You can set it to compact/repair on close. There are compactdatabase and repairdatabase methods in VBA, both for DAO and ADO.

Kevin

dartcoach

Thanks Kevin,
Our databases are on the network with domain users login. I need to run the utility as a service during the downtime like late evening or early mornining. I did check the vba code and also Total Visual Agent vendor application. I need a compact-repair application that runs from user login and not as administrator login.
Thanks again for researching and let me know of other products.

Surajguru,

A question then, do you want to run this when a particular user signs in, or at a specific time, or both? If it's a time setting, you can use the timer event to do it. If it's a user setting, you can do that at that user's sign in, or if it's both, use both.

Kevin

dartcoach

I take it you have a back end that you want to compact and repair.

You could write a scheduled script that opens and closes the database back end directly at a certain time on your network, and then set up the back end to repair and compact programatically.

That is cheap and easy.

HTH

mmcdonal

I use this for all my clients:

Total Access Agent

Most people do not know that you should only compact a database that is local (on the PC's hard drive). You should avoid compacting a DB across a network. Large databases can be corrupted.



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com