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:
1. | Build a query based on the SQL ... |
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
