Science, Tech, Math › Math How to Split an Access 2010 Database into Front-End/Back-End Components Share Flipboard Email Print Math Statistics Statistics Tutorials Formulas Probability & Games Descriptive Statistics Inferential Statistics Applications Of Statistics Math Tutorials Geometry Arithmetic Pre Algebra & Algebra Exponential Decay Functions Worksheets By Grade Resources View More By Mike Chapple Writer University of Idaho Auburn University Notre Dame Former Lifewire writer Mike Chapple is an IT professional with more than 10 years' experience cybersecurity and extensive knowledge of SQL and database management. our editorial process Twitter Twitter Mike Chapple Updated February 15, 2019 01 of 05 Open the database you wish to split Busakorn Pongparnit / Getty Images As a general rule, it's inadvisable to provide multiple copies of access databases to other users without making the front end of the database inaccessible. Data corruption may result. So, how do you handle it when you want to share the data itself with other users in your organization who may, in turn, wish to create their own forms and reports using that same data? You may want them to have the ability to view and/or update your data, but you definitely don't want them to modify the interface you've used to work with the data yourself and that contains other database objects. 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, providing each user a local copy. If you're working in a multi-user environment, another benefit of this useful technique is that giving colleagues the data without an active interface can make a considerable difference in network traffic. It also allows front-end development work to continue without its affecting the data or interrupting other users on the network.From within Microsoft Access 2010, choose Open from the File menu. Navigate to the database you wish to split and open it. 02 of 05 Start the Database Splitter Wizard To split a database, you'll use the Database Splitter Wizard. Go to the Database Tools tab of the Ribbon, and, in the Move Data section, select Access Database. 03 of 05 Split the Database Next, you'll see the wizard screen. It warns you that the process may take a long time, depending upon the size of the database. It also reminds you that this is a risky procedure and that you should make a backup of your database before proceeding. (This is certainly good advice. If you haven't already made a backup, do it now!) When you're ready to begin, click the "Split Database" button. 04 of 05 Choose a Location for the Back-End Database You'll see the familiar windows file selection tool. Navigate to the folder where you wish to store the back-end database and provide the filename you wish to use for this file. As a reminder, the back-end database is the shared file that will contain the data used by all users. Once you've named the file and selected the appropriate folder, click the Split button to begin the split operation. 05 of 05 Database Splitting Complete After a period of time (which varies depending upon the size of your database), you'll see the message "Data Successfully Split" in the Data Splitter window. When you see this, the splitting operation is complete. Your back-end database is now stored using the name you provided. The original file still contains the front-end portion of the database. Congratulations, you're done!