Alison Balter's Mastering Access 2002 Enterprise Development

Proactively Preparing for Upsizing

If you set up your tables and code modules with upsizing in mind, you can eliminate many of the pitfalls discussed previously. Despite any of the problems that upsizing can bring, the scalability of Access is one of its strongest points. Sometimes resources are not available to implement client/server technology in the early stages of an application. If you think through the design of the project with the possibility of upsizing in mind, you will be pleased at how relatively easy it is to move to client/server technology when the time is right. With the Access 2000 and Access 2002 Upsizing Wizards, which are designed to upsize an Access application to Microsoft SQL Server, the process is relatively simple. The ...