Microsoft Access Database Backups

As MS Access Database Developers and Consultants would know, one of the most oft-mentioned pieces of advice is database backups, preferably to multiple types of media and multiple locations. Backups are still the best method of retrieving lost data, and for reverting back to old copies of data, although it is inconvenient at times luckily most systems have automated methods of backing up or they are made as simple one or two click operations.

Although most people would never say that backups are useless or aren't required, a lot of people don’t bother with it. Usually it only takes one or two lost databases, assignments or another piece of work to convert most people to using backups. As good as backing up every now and then is, unless it is done regularly then it can be as useless as no backups, with regular backups you know you won’t lose too much work when something happens.

The most obvious means of losing data is power failure when the database is corrupted, although this is probably the most common way of losing data, there are still plenty of others. Physical damage to the location of the database can cause data to be lost, whether it is fire, theft, broken equipment, floods and a myriad of other reasons why it could break.

Luckily for Microsoft Access Database Developers and Consultants, backing up in MS Access 2010 is a simple task, one only needs to click “File”, then select “Save & Publish”, where the option to create a backup is listed. With backing up as easy as this, Developers and Consultants have no reason to not backup their databases regularly.