MS ACCESS 2003 - code to execute compact/repair in case database gets corrupted or should I do some thing else?
Posted on 2007-04-04
I'm pretty new to MS Access 2003. I've got a full registration program going and it totally locks out all of Access menu's (soon will do shortcuts). From what I've been reading about Access's databases is that they can "easily" get corrupted. (I have sharing on and record locking on both the BE and FE).
Since I have not experienced a corrupted MS Access database yet, I can not tell if the built in Access "compact and repair" feature would fix most corrupted tables in the database...
(The users will not have access to the tables or Access themselves.. they are running through my VB application so I'm looking for an answer they they would be able to do themselves.)
***Also the FE is a MDE***
So my questions are:
1) Does the built in compact/repair feature fix most corruptions? (i understand what the compact side does...)
2) If yes then what code can I use to have the user click a command button to compact/repair
If not.. what is my best solution to cover my butt.