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

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 a copy of a desktop database that uses linked tables to the shared file and that contains all your queries, forms, reports, macros, and modules. You can read more about how to split a desktop database in Chapter 31, “Distributing Your Application.”

If you have already split your database, you should consider upsizing if any of the following become true:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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