 |
(D.C. Conlin) Are you building a multi-user database for your organization? When you are finished developing your database, split the production database into a front end and a back end. The back end will contain the tables, as well as the relationships you have defined for those tables in order to maintain referential integrity. The front end of your database will contain the application objects: queries, forms, reports, data access pages, macros, modules and temporary tables. Lookup tables that rarely change are also good candidates for the front end. The front end will also include the links to the tables contained in the back end database. |
