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

Hour 20. Database Administration > Using the Database Splitter

Using the Database Splitter

When you're designing an application, you should split the application objects into two separate .MDB files. One .MDB file should contain the tables, and the other should contain the application queries, forms, reports, data access pages, macros, and modules. This allows you and others to enter data while you continue to refine the other application objects. When you need to make changes to the application, you simply copy the application database. When you have made the appropriate changes, you can copy the application database over the production copy without overwriting the data in the data database.

To split the objects in a database into two separate .MDB files, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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