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

Splitting a Database

In a large organization, different people will have different uses for the information in a database. They might want to develop their own variations of your queries, forms, and reports, or even create their own. Allowing dozens of people to edit the objects in a database leads at best to confusion and at worst to disaster.


One easy solution to this problem is to split the database into a back-end database, containing the tables, and a front-end database, containing the other database objects. You can store the back-end database on a server and distribute the front-end database to all the people who work with the data. They can use the queries, forms, reports, pages, macros, and Microsoft Visual Basic for Applications (VBA) code that you developed, or they can write their own. Although everyone still has access to the data in the tables, and there is still some potential for corrupting the data, the rest of your database objects are secure.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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