Automatically compact password protected db?

[michelleb1]

I need to find a way to automatically compact my backend, if possible in the middle of the night when nobody is there. It is used pretty much all day by at least 5 or 6 people everyday. Every so often, I get the message: unrecongnized database format. When I compact and repair the backed it always works. I'm hoping the a daily compact will help the problem?

I have enlisted the help of a person who says that he can create a .BAT file to automatically compact the database BUT that it cannot pass the password. So, he can make it work if I have the backend unprotected, which I'd rather not do. He says this is a known problem, checked the microsoft site, and that there is no way around this. Is this true??

Thanks, you guys are always brilliant!

 

[cghoga]

You can set the database to compact on close.
Go to Tools - Options, select the General tab, then check the Compact on Close option.
Would this work, or do you need the app up all the time?

If so, there is a way to pass the password through the command line. I'm sure someone in this forum knows the answer.

Hope this helps.