1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

Splitting an Access Database, Step by Step

By

1 of 5

Open the database you wish to split
Oftentimes, you wish to share data with users in your organization who may, in turn, wish to create their own forms and reports. While you may want them to have the ability to view and/or update your data, you may not wish them to modify the interface you use to work with the data yourself. Fortunately, Microsoft Access provides the ability to split a database into front-end and back-end components. You can safely share data with other users while keeping your interface private.

From within Microsoft Access, choose Open from the File menu. Navigate to the database you wish to split and open it.
  1. About.com
  2. Technology
  3. Databases
  4. Microsoft Access
  5. Tutorials
  6. Splitting an Access Database, Step One: Open It

©2014 About.com. All rights reserved.