• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. A Strategy for Developing Acc... > Splitting Tables and Other Objects

Splitting Tables and Other Objects

In a multiuser environment, it's almost imperative that the tables that make up your system be placed in one database and the rest of the system objects be placed in another database. For simplicity, I'll refer to the database containing the tables as the Table database and the database with the other objects as the Application database. The two databases are connected by linking from the Application database to the Table database. Here are the reasons for this strategy:

  • Maintainability

  • Performance

  • Scalability


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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