Deciding When to Upsize

If only one person is using your desktop database, you typically won’t need to upsize the database unless it’s getting very large (greater than 500 MB). You’re more likely to need to upsize when you have multiple users sharing the application. If you originally placed the entire database (tables, queries, forms, reports, macros, and modules) on a network share for two or three users, and you now have additional users that need to run the application, or you’re experiencing performance or corruption problems, you should first consider splitting the database. You can greatly improve performance and reduce corruption problems by placing all the tables in one desktop database file on a file server share and giving each user ...

Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.