O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

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

Splitting a Database

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

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