You could probably benefit from looking at Allen Browne's article found here:
Preventing Corruption
To his recommendations I'd add that you deselect the Compact on Close as compacting is considered, by many, to be one cause of corruption, and shouldn't be done without first making a backup copy of the file. There really is little reason to do a compact on a regular basis like this.
In 2007 you'd go to
- Click on the Office Button (top left)
- Click on Access Options (bottom right of dialog box)
- Click on Current Database(left)
- Untick Compact on Close
- Click Okay
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007