Access DB getting corrupted?

[kovas]

Sometimes when ppl just power off their pc without shutting down properly my access db gets corrupted, I usually just repair it and its fine after that. But until i repair it the app gives an error saying DB not recognized. Is there someway I can automate it to repair it self without me doing it manually to avoid down time?

 

[ajdesalvo]

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. Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"