| With the continuous use of Microsoft Access | | | | your local file system. The back-end database is |
| database, size keeps growing. When it become | | | | accessed through the linked tables and |
| very large, the database (either MDB or AccDB) | | | | unauthorized access is prevented using file |
| may start performing slowly, freezing, and | | | | system security options. |
| crashing. In such cases, you should consider | | | | Enhanced Reliability- If you run across any |
| splitting the database. You may also need to split | | | | problem and your database is terminated |
| it if multiple users access it simultaneously over | | | | improperly, corruption is generally limited to copy |
| the network. Splitting improves the performance | | | | of front-end database that is stored locally on |
| of the database, minimize the possibilities of | | | | your computer. Because back-end database is |
| database corruption, and prevent need of MDB | | | | accessed only through the linked tables, chances |
| repair solutions. | | | | of corruption are very limited. |
| You should not confuse database splitting with | | | | Greater Database Availability- Since only data is |
| archiving. However, in some situations, it is | | | | sent throughout the network, Access file |
| possible to archive the database by splitting it. | | | | transactions like record editing are accomplished |
| When a database is split, it is organized into two | | | | more quickly thus leaving your data more usable |
| different files - one back-end Access file that | | | | for editing. |
| holds only data tables and one front-end file that | | | | In case you encounter corruption on a split |
| holds all other objects like forms, queries, reports, | | | | database, you can easily recover Access |
| modules, and VBA codes. The user directly | | | | database by restoring it from the most recent |
| interacts with data using local copy of front-end | | | | backup. For absolute recovery, the backup must |
| Access database. | | | | be validated. |
| Advantages of Access Database Splitting | | | | If backup is not valid or updated, this recovery |
| Enhanced Performance- The database | | | | software becomes need of hour. The applications |
| performance is significantly improved after splitting | | | | enable you to recover MDB file in a simple, quick, |
| because only data is sent throughout the network. | | | | and safe way. They are incorporated with |
| You need not to use objects over the network. | | | | attractive graphical user interface and read-only |
| Improved Security- When you store database on | | | | conduct. |
| back-end, you can use the security features of | | | | |