Your boss comes to you a month later with a new problem. Network traffic is increasing because new employees have been hired to accommodate a new client. They, too, must have access to the database. Performance is again decreasing, but for a different reason this time. You have a brainstorming session with other computer professionals, and decide to split the database into two databases: one for the tables and the other for the forms, reports, macros, modules, and other objects.
If this scenario happened in the real world, you would have several options open to you, which would include the following:
Splitting the database into two databases, as suggested in the scenario.
Using an Access project.
Turning your database into an intranet ...