Process of selecting the tables to move, and what the your data file In Access 2000/2003, select "Tools>Database Tools." from the menu, then "Database Splitter." In Access 2007/2010, select the Database Tools ribbon tab, then "Moveĭata" and then "Access." The wizard will take you through the Be sure to make a copy of your database before you begin just to be safe. Splitting your database is quite easy with the built-in Access tool. ToĪvoid this, you provide each end user with their own front-endĭatabase file, each linked to the same Access Data File. Locking, you may still receive errors that another user isĬurrently in the database and you cannot make changes. Have difficulty when multiple users attempt to open the sameĭatabase file. Objects in one file, including your tables, Access will usually Avoid Multi-User Collisions If you store all your Version of your front-end file and their data remains intact. With a splitĪccess database configuration, you simply send them a new Users to import their existing data tables. The data would be overwritten, or you would have to ask the Sending users a new version won't work, as Particularly if you plan to deliver your database to users at aĭifferent location where you don't have direct access to theĭatabase file. Tables also presents a problem when you need to make updates. Upgrade Your Front-End Databases without Data Loss Storing your forms/reports/macros/VB in the same file with your Prompt the user to find the new location. Links to the new location, do so programmatically, or use a tool If it moves, you can manually restore the The front-end database file(s) always know where the Access Dataįile resides. (as long as your machine is on when the file is needed by otherīack up your Access Data File whenever you need to, and Shared network drive or even a shared folder on your own machine Separated from the user interface (forms/queries/reports) andīusiness logic (VB/macros), you can keep the data anywhere that Store your data file anywhere With your data