Any Reviews of Automated Compact/Repair Tools?

[smedvid]

I am searching for a point and click tool that can automatically compact/repair Access-97, Access-2000 and Access-2003 databases (MDBs) in various network directory shares. MDB files account for approximately 60% of the files on our network, and I am looking to recover diskspace.

I actually created an MS Access based compact tool myself many moons ago; but I would rather purchase a COTS and forego any development/maintenance efforts.

Any suggestions/comments related to specific COTS are more than welcome.


Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[anon1971]

That feature is on access already unless I am missing a higher point.

 

[smedvid]

Ok... I have 3500 MDB files; which I would like to compact on a monthly basis to ensure that we are conserving network disk space. If users enable the auto-compact and repair on exit; in some cases they may need to wait 5 minutes (or more) especially on MDB files that are over 1.5GB. I hope this explains the issue...

Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[PHV]

You may use the standalone db compacter:

http://support.microsoft.com/kb/295334/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886