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.