Six Ways to Prevent MS Access Database Corruption
The Access Database that you use to manage most or at least part of your business is contained in one or two files. When one of these files corrupt, you’re down until you can either fix the problem or restore the database from a backup. These easy to follow suggestions will help to minimize the potential of corruption.
For instructions on how to fix a corrupted Access Database, click here
1) Back Up Your Database
Whether you use an online backup service, a tape drive or simply email the files to yourself, be sure to back up your database every day. Keep in mind that there may be two files. The program file on your computer (the “front end”) and the data file (“back end”) on the network. Not all corrupt database files can be repaired.
2) Avoid Power Problems
Close access before you shut down your computer. Put a UPS (Uninterpretable Power Supply/Battery Backup) in place for protection in the event of a brown out or a power failure. Keep the cords for your computer tucked away so you don’t trip on them and pull a plug. Personally, I use a laptop computer and keep it plugged in. If there are any problems with the power, the battery takes over and I’m good to go.
3) Keep On Top of Windows (and other) Software Updates and Service Packs
Access is a large, complicated program that is tied into many aspects of your operating system. Furthermore, many (probably most) software applications share a lot of your operating system with Access. And on top of that, there are a heck of a lot of programs out there that actually install and/or use portions of MS Access itself in order to run. Its important that you keep your computer and your programs up to date with service packs and software updates. If there are any programs on your computer that tend to misbehave and affect Access, consider deleting, updating or replacing those programs.
4) Keep Your Computers and Wiring in Good Shape
Intermittent network cable connections, computers that overheat, bad network cards, over-stuffed hard drives ready to run out of space, etc. These kinds of problems pose a threat to your computers and your software. Have your systems checked out every now and then and keep an IT guy on-call. Give me a ring if you need a referral to an IT pro in the Los Angeles area.
5) Split The Database
If you share the database between more then a few people, split your database into two parts. A “Front End” (program file) and a “Back End” (data file). This is almost always quick and easy job for someone (like me) who’s familiar with Access.
6) Keep the Database Size in Check (Compact and Repair your Access Database)
Repair and compact your database on a regular basis (once a week, for example). Note that the maximum size of an Access database is 2 gig. If your database exceeds this size it will corrupt. Performing the compact and repair procedure is quick and easy, and its cheap insurance. (See Step 7 in the Access Database Repair Guide for instructions on how to Repair and Compact an Access database.) In addition to keeping the size of your database to a minimum, this simple maintenance procedure will scan your database for problems that may have not yet surfaced, and keep your database running as fast as it can.