O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Scalability

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required