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

Chapter 11. Developing an MDB Client/Ser... > Working with Local Tables

Working with Local Tables

The use of local tables reduces the resources required on your SQL Server, therefore improving the scalability of your application. Any table whose data does not frequently change is a candidate for a local table. Excellent choices are tables that you use to populate combo boxes and list boxes. The form called fsubOrderDetails provides such an example. The cboProductID combo box uses a table called tblProducts_Local as its RowSource. To work with local tables, you need to be concerned with only creating them and then updating them from their SQL Server counterpart as needed.

Building the Local Table

The process of building the local table is quite simple. Here are the steps involved:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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