KNOWING WHAT TO WATCH FOR IN APPLICATION DEVELOPMENT
When developing client/server applications, you need to watch out for many things if you plan to migrate to client/server. These include—but aren't limited to—limiting your data, using combo boxes, using Access-specific and user-defined functions, creating heterogeneous and cross-database joins, dealing with ActiveX objects, and using local Access tables.
Limiting Your Data
In client/server development, it's very important to limit the amount of data being sent back and forth across the network and to retrieve only the columns and rows you need. If you read nothing else in this section, leave it with the message that limiting your data is crucial.
Moreover, design your forms with this in mind. ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming 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.
