You can create a batch file (DOS anyone?) that you could run when the computer restarts.
For example, in notepad create a file called repair.bat.
Add a line with the location of the msacces.exe and the location of the database to repair and compact, then the /repair /compact parameters.
The line of text looks something like this:
c:\program files\ms office\office\msaccess.exe c:\My Program Directory\My.mdb /repair /compact
Go to the Windows Startup Folder and add a shortcut to the repair.bat file.
The next time Windows starts, the batch file will run and if you are lucky, repair and compact the database.
The second thing you will need to do is slap the ppl on the back of the hand/head about powering down the pc without shutting down Windows.
![[mad] [mad] [mad]](/data/assets/smilies/mad.gif)
Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"