Access as a Scalable Product

One of Access's biggest strong points is its scalability. An application that begins as a small-business application running on a standalone machine can be scaled to an enterprise-wide client/server application. If you design your application properly, scaling can be done with little or no rewriting of your application. This feature makes Access an excellent choice for growing businesses, as well as for applications being tested at a departmental level with the idea that they might eventually be distributed corporation-wide.

The great thing about Access is that, even acting as both the front end and the back end with data stored on a file server in Access tables, it provides excellent security and the capability to ...

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.