Linked Table Gotchas
The main gotcha with linked tables is that it is way too easy to accidentally bring much more data over the network wire than is required. This is most commonly caused when a form is based on a table or on a query that brings back all of the rows from a table. Ensuring that you provide the user with a means for selecting only the data that he needs in each form and then basing the form on that criteria eliminates most of the problems inherent with linked tables.
Another gotcha with linked tables involves connections. Multiple combo boxes on a form utilize multiple connections. Basing static combo boxes on local tables greatly reduces the number of connections that each user consumes, thereby making your application more scalable. ...
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.
