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 ...
Get Pro Access 2010 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.
