• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Developing Multiuser and Ent... > Proactively Preparing for Upsizing

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 stronger 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 2003 Upsizing Wizard, which is designed to take an Access application and upsize it to Microsoft SQL Server, the process is relatively simple. The upsizing tools for Access 2003 perform a lot of the work involved in upsizing a database, with just the click of a few buttons.

NOTE

Client/server development and client/server issues are covered in extensive detail in Alison Balter's Mastering Access 2002 Enterprise Development.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint