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

Summary

You should perform the compact process regularly—especially on databases containing your application data. The compact process provides major benefits in terms of both performance and conservation of disk space. The more activity that occurs on a database, the more frequently you should compact it. Although you should consider the compact process an important part of the database maintenance process, remember that there is absolutely no substitute for proper backup techniques. This chapter also showed you a new feature included in Access 2003 that allows you to back up an open database.

In addition to compacting your database, it is important to understand the database conversion options available to you. You can convert databases from one version of Access to another using either the user interface or code. Finally, whereas it was an arduous, time-consuming process to detect broken references prior to Access 2002, the BrokenReference property makes this process much easier, by reporting whether all database references are intact. Using all of the techniques covered in this chapter should save you a lot of time and effort in maintaining and working with your databases.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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