• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Making It Easy for Others to ... > Keeping Your Application Healthy

Keeping Your Application Healthy

In the day-to-day use of an Access database—adding and deleting records, modifying forms and reports, and so on—various problems can develop. This is especially true if the database is stored on a local area network and is accessed by multiple users. Access monitors the health of database files as you open and work with them. If it sees a problem developing, it attempts to fix it. If Access can’t fix a problem, it usually displays a message suggesting that you take some action. But Access doesn’t always spot problems before they affect the database, and sometimes database performance seems to slow down or become erratic. Even if no serious errors creep in, simply using a database causes its internal structure to become fragmented, resulting in a bloated file and inefficient use of disk space.


You don’t have to wait for Access to spot a problem. There are various things you can do to help keep your database healthy and running smoothly. Your first line of defense against damage or corruption in any kind of file is the maintenance of backups. Database files rapidly become too large to conveniently back up to floppy disk, but you have many other options: you can copy the file to another computer on the network, send it as an e-mail attachment to another location, use a tape backup, burn a CD-ROM, or copy it to some other removable media.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint