In the computing world, backups play a crucial role in protecting your data during unfortunate circumstances. In case of Ms Access, the need to take regular backups is very essential as the application remains vulnerable to several issues. It is a well known fact that Ms Access database has a relatively compact limit of 2GB for most iterations and even if the database size reaches the 1GB figure, it can start to behave inconsistently. Moreover the Access database remains acutely vulnerable to crashes and other errors during the development stage of an application built to run to on it. In fact it can even get compromised by errors that occur when you test a module. Further the application when used in a multiuser environment remains susceptible to flaws which range from locking issues arising out of network connectivity or unstructured input which generate errors. Thus it is imperative that regular backups are made for the Ms Access database without fail.
Backing up a database in Ms Access
To backup a database in Ms Access you should first finalize the location where you would like to backup the data files. Ideally it should be stored at a separate location, or in a removable media drive. To backup the Access database, please follow the steps listed below
- Launch the Ms Access database
- Next open the specific database file that you wish to backup
- Once done go to the Ms Office button and head to Manage Menu item
- Next click on the option to Back up Database from the present menu
- In the subsequent dialog box, choose the destination where you wish to save the backup copy of the database.
- Next just hit the Save button to backup the database.
Note: The steps above may vary based on the version of Ms Access you are running
The frequency with which you backup the database depends on the business application you are running and its importance. While some businesses may be happy to take weekly backups, if you are running a critical application where data loss can cause issues, a regular daily backup is suggested.
Recovering the Ms Access Application data from a crash
While backups can help you recover the data that you had previously saved, it cannot get back the data stored since the last backup session in the event of an Ms Access crash. The only way to get back the recent data would involve the use of an access recovery tool like DataNumen Access Recovery. It comes loaded with sophisticated recovery algorithms to pry out data from a compromised MDB file with ease. Further it has the capacity to deal with every other media type that you can throw at it, from Iomega disk drives to floppy disks. In some rare cases the corrupted MDB file may not be found at its usual place and in such situations you can use this utility as an e-discovery tool.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access repair and sql recovery software products. For more information visit www.datanumen.com