O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

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

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 ...

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