O'Reilly logo

Pro Access 2010 Development by Mark Collins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Upsizing

From a developer's perspective, having the data and UI elements such as forms and reports in a single database is great. You can make a copy of the database, try out some ideas, test it... and if you don't like the results. just delete it and go back to the original database. It's also very convenient; you don't have to configure database connections, you just open the file like you would a Word or Excel file. However, if you have more than just a few users, these same benefits will become your biggest issues.

Understanding Upsizing

There is some debate as to just how well Access will scale to support more users, data, and throughput. Before you come close to any of these theoretical limits, however, you will need to split your ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required