Split Database Architecture

MS Access database allows you to create large database as per your requirements. The Access database contains numerous tables, views, reports, forms, stored procedure, triggers and more. When you add more database components to the database, the size of the Access database becomes larger and the overall designing of the database becomes critical. The best possible way to reduce the criticality and avoid errors is by splitting the Access database into a front-end and back-end database.

You need to take an existing Access database file- MDB or ACCDB- and divide it into two databases:

• The "Front-End" database contains the links and application objects to the tables in the back-end database
• The "Back-End" database only contains the tables

Splitting of the Access database is mainly performed in multi-user environments where multiple users can access the shared data saved in back-end database. Each user also contains a copy of the front-end database which points to the back end database. The user can split the database manually or by using the Microsoft Access Database Splitter Wizard. To manually split the data, the user needs to follow these steps:

1. Firstly, the user needs to firstly copy the Access database.

2. Secondly, the user needs to then delete all the non-table objects from one of them and make that your back-end database.

3. Finally, the user needs to delete all the tables from the other "front-end" database, then link to the tables in the back-end database.

An access database can be corrupted when the user performs splitting either manually or through Microsoft Access Database Splitter Wizard. Interruption in deletion or linking of tables can terminate of splitting process in between and can leave the Access database in partially split state. In such scenarios, the user needs to use effective Access Recovery Software to repair and recover the corrupted Access database.

Stellar Information Systems Limited provides the best Access Recovery utility named - Stellar Phoenix Access Recovery Software. This is a third party application that ensures complete Access database Repair in all Access database corruption cases. This Access Recovery application provides interactive user interface and works on Windows Vista, 2003, XP, 2000 and NT. It is compatible with Access 2007, 2003, XP and 2000. The demo version of this Access Repair application enables you to preview the lost Access database.