Compact and Repair in off hours

[Spin]

I am trying to find a way I can compact and compair a whole slew of databses I have created that are constantly being accessed and worked on throughout our working day. I would like to do this via a Windows Batch file in Schedular or somehting during off working hours. I know it would require that I access each file and somehow turn on some internal file within each database to compact and repair. I am novice at Windows batch file and would like some help.

[ADezii]

I am trying to find a way I can compact and compair a whole slew of databses I have created that are constantly being accessed and worked on throughout our working day. I would like to do this via a Windows Batch file in Schedular or somehting during off working hours. I know it would require that I access each file and somehow turn on some internal file within each database to compact and repair. I am novice at Windows batch file and would like some help.

This should point you in the right direction. The following Batch File called CompactDB.bat will Compact and Repair the Test.mdb Database in the C:\Test\ Directory then close Access. The Batch File assumes the Default install location for Access 2000, make you own modifications if needed:

@echo off
cls
cd C:\Program Files\Microsoft Office\Office
msaccess.exe C:\Test\Test.mdb /compact

[Spin]

Thanks...I'll give it a try. Then I guess I'll need to research Windows Scheduler to see if I call this batch file after hours... See what happens.