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 2010 Database into Front-End and Back-End Components

By

1 of 5

Open the database you wish to split
You might 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 2010 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 2010, 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. Access 2010 FAQ - Front-End and Back-End Database Components

©2014 About.com. All rights reserved.