How to Back up a Split Database in Your Access

In this article we look at backing up a split database in an effective manner in quick time

Backup A Split Database In Ms AccessSplitting Databases is one of the easiest ways to manage databases. Every time your database grows too much, splitting it into two databases – Front-end and Back-end, is always the most preferred solution. For a company, which has an ever expanding Access database, it is crucial to split them, before accessing them. Once a database is split, it is not only easier to manage but also easier to backup. There are lots of advantages of splitting databases, but that is not what we will be discussing in this article. Here we will understand how we can backup split databases and why is it important to do so.

Backing up a split database is as important as splitting the database. For a company that uses Access, there might be multiple reasons for splitting a database, ranging from too large databases to creating a distinction between Front-end and Back-end. However for backing up data, there is only one reason – to recover data during a disaster. And this is reason enough for all users to be particular about backing up their Access databases. Backing up a split database requires you to separately back up front-end and back-end databases. Here are the steps you should follow for backing up split databases.

Backing Up the Front-end of a Split Database

The front-end of a database contains all the database objects like queries, reports, forms and links to tables in the back-end. It contains all the user interface objects. You should back up the front-end of a database every time you make changes to it.

  1. After you have made changes in the front-end, leave the database open.
  2. Go to Microsoft Office Button > Manage > Manage this Database > Back up Database.Back Up Database
  3. The appearing Save as dialog box will contain a File Name Box, enter a file name and backup the database.
  4. Select location for saving the backup in the Save As dialog box. End by clicking Save.Save The Backup Database

Backing Up the Back-end of a Split Database

The back-end of a database contains all the tables, the links to which are available in the front-end. All the data in a database is contained in the back-end.  To be able to backup data in the back-end., you will first have to open it in exclusive mode.

  1. Once the database is opened in the exclusive mode, go to Microsoft Office Button > Manage > Manage this Database > Back up Database.Back Up Database
  1. The appearing Save as dialog box will contain a File Name Box, enter a file name and backup the databases.
  1. Select location for saving the backup in the Save As dialog box. End by clicking Save.

There can be multiple scenarios where one can use split databases, while making use of split databases what the user should always keep in mind is the fact that backing up split databases is indispensable. Just like you pay attention to backing up databases that are not split, you also have to pay attention to backing up split databases.

Dealing with a Corrupted Split Database

In some cases even a split database can become corrupted. If you encounter such a scenario, just run an accdb fix tool to recover the compromised components in quick time. However make it a point to ensure that the recovery tool you choose can handle large Access files since the back end database is typically quite large in case most production Access databases.

Author Introduction:

Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair SQL and excel recovery software products. For more information visit www.datanumen.com

Comments are closed.