How to Keep MS Access Database Safe

Data stored in the MS Access database file is a valuable asset for developers; therefore, they cannot keep the data unsafe. From keeping the data safe, we mean from various things like data stealing, data loss, etc.

Anyone who uses MS Access database file can come across the data loss if the file gets damaged or if any intruder gets access to the file and intentionally delete or modify the stored values. This article provides information about how one can keep the database safe and protected. Following are the different ways of keeping database safe:

1.Apply Password: To keep the data stored in the database safe, you must apply strong password on your database file. Execute the following steps to apply password on .mdb file:

1.Start MS Access.
2.Select File > Open. The “Open” dialog box appears.
3.Select the .mdb file on which you want to apply the password.
4.Click the down arrow beside the Open button and select the Open Exclusive option.
5.Select Tools > Security.
6.Select the Set Database Password option.
7.Enter the password.
8.Click the OK button.

2: Split the Database: You should split the database to keep the tables and relationships in one database while interface objects in another database. Both databases will communicate through the tables that are linked in them. This is not only increase the performance but also prevents the size of the database from increasing. Splitting database is very much useful because the chances of the damage of the large sized database are always more than a small sized database.

3. Do not Compact the Database while Closing: When you close the database, you may be asked to compact the database. Compacting the database is good to free the available extra space but when you compact the database then temporary data will be deleted. You should compact the database manually instead of compacting it automatically.

This way you can keep the .mdb file safe. Sometimes, the .mdb file gets damaged due to various known and unknown reasons. At that time, you should use the Kernel for Access Repair  software to protect you from data loss. Once the .mdb file is damaged, data stored in it becomes in accessible. Kernel for Access Database Repair effectively repairs the damaged .mdb file and helps you recover the lost data. The software supports MS Access 2003, 2000, 97, and 95.

Comments are closed.