This article focuses on understanding the importance and use of Split database while also addressing steps to create its backups.
As the name suggests, split database is created by splitting two database files which are:
- Back-End Database – consisting of data available in tables
- Front -End Database – consisting of links connecting to all the tables present in the back-end database including forms, queries, reports etc.
Note that back end database consists of all the data in the system. Whereas all user interface data Objects like forms, reports etc. is stored in front end database. Front end database can be seen as the first layer of data, which is accessible to all. Anyone can go through the information available in the front end database. But the user needs to get an administrator permission to access the back end database. This split end division of database is what makes Access so secure and sound.
Since both these databases have different properties, their databases are also backed up independently. Front-end database consisting of minor form of data consumes less space, which takes less time in creating its database. However creating backups for back-end database can be a time consuming process. But as it contains all the data, it is important to generate regular backups for it to avoid incidents of corrupted Access databases.
Steps to create Backup for Back-end Database
Note: Make sure to notify all the users on the system about the backup on the back-end database. Running a backup requires an exclusive access to all the files of database, which disable users from using the database during the backup process.
Tip: Usually organizations run backups during holidays to ensure that the data remains undamaged and the work efficiency is also maintained.
- Step 1: Open Access without opening any database.
- Step 2: Click on Open and select the database file you want to backup.
- Step 3: Click on the arrow > next to Open > Select Open Exclusive.
- Step 4: Click on the File Tab.
- Step 5: Click on Save & Publish.
- Step 6: Now go to ‘Save Database As’ section, right under ‘Advanced’ option and click on BackUp Database.
- Step 7: Once the backup is created users can save the File.
Tip: Users can save the file with the original name and add backup in front of it, to help them easily identify the file in the future.
Steps to create Backup for Front-end Database
Since the front end database is accessible to most users in an organization, they all have a separate copy of that database. Users can customize and redesign their copy according to their liking. Note: each individual needs to generate backup for their front-end databases especially if they want to see their customized arbitrary design changes in their front end database.
Note: These changes made in the front-end database will only be visible to the user, making the changes as other users will have access to their own front-end database.
- Step 1: Users can make design changes and other basic modification in the database.
- Step 2: Once the user has saved all the necessary changes in his/her frontend database file, he/she can repeat the step mentioned above for creating database backup for back-end database to create a backup for their front end database.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair SQL Server and excel recovery software products. For more information visit www.datanumen.com