
If a database is shared with several people over a network, you should consider splitting it. Splitting a database reorganizes it into two files — a back-end database that contains the database's tables, and a front-end database that contains all the other database objects such as queries, forms, and reports.
There are a number of benefits to splitting a database, including:
- Enhanced Security: If you have saved a back-end database to your computer that uses the NTFS file system, you can use the NTFS security features to secure your data. Since users will access the back-end database through linked tables, it is more difficult for unauthorized users to access data from the front-end database.
- Greater Availability: Since a split database's data is sent across the network, actions made in it are usually quicker to complete, which allows the data to be more available to edit.
- Improved Performance: Splitting a database usually significantly improves its performance because only its objects' data are sent across the network, not its actual objects.
- On your computer, make a copy of the database you want to split.
- Open the local copy of the database.
- Click the Database Tools tab on the ribbon.
- Click the Access Database button.
The Database Splitter Wizard appears.
- Click Split Database.
The Create Back-end Database dialog box appears.
- Specify a name, file type, and location for the back-end database and click Split.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.
- Specify a name, file type, and location for the back-end database and click Split.