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

Chapter 21. Taking Charge of Forms > Using Forms to Optimize Large Tables

Using Forms to Optimize Large Tables

What do you do when your tables become so large that they are slower than molasses? When tables become large, users start complaining. No matter how creative your application is, if it’s slow, it won’t be as impressive. If you have applied all the optimization techniques in this book and are still plagued with speed problems, your best option could be to limit the size of the table. You can break up tables that have too many fields by applying the normalization principles from Chapter 1, “Planning and Designing Your Access Database.” But assuming that this has been done, there are other alternatives.

Append Obsolete Records into Another Table

One alternative that you might consider is to delete obsolete records. The only problem with that option is that you never know when you might need to access those records for legal purposes. You can create an archive table for obsolete records that can be appended from your form with code like the following:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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