Back up a database – access

You should regularly back up any active database to guard against data loss and to protect your investment in your database design. Data recovery professional Using a backup, you can easily restore an entire database or selected database objects.

If the number of records in your database grows regularly, you can also consider archiving the old data. Data recovery images Archiving is the process by which you periodically move older records from a table in an active database to a table in an archive database.


Database management system This article does not explain how to archive old data.

If you want to automate creating backups of database files, consider using a product that performs automated backups of a file system, such as file server backup software or a USB external backup device. Sony xperia z data recovery This article does not discuss ways to automate the creation of Microsoft Office Access backups.

In Microsoft Office Access 2007, you can use the Undo command up to 20 times to reverse changes that you made since the last time that you saved your database file.

However, when you use an action query to delete records or to change data, you cannot undo those changes by using the Undo command. Note 3 data recovery For example, if you run an update query, any old values that were updated by the query cannot be restored by using Undo.

Tip: Consider making a backup immediately before you run any action query, especially if the query will change or delete a lot of data. Database image Not all changes in a database can be undone

Although Access offers you the option to reverse changes that you decide you did not want to make, the process is not foolproof. S note data recovery To prepare for recovery from unwanted changes that you cannot undo, you should make backups of your database. Database 4d Regular backups are essential

If your database is an archive, or if it is used only for reference and rarely changes, you should make a backup every time that your data changes.

Note: You should back up the data in linked tables by using any backup features that are available in the program that contains the linked tables. List of data recovery software If the database that contains the linked tables is an Access database, use the procedure in the section Back up a split database to back up that database.

When you back up a database, Access saves and closes any objects that are open in Design view, compacts and repairs the database, and then saves a copy of the database file by using a name and location that you can specify. Types of data recovery Access then reopens any objects that it closed.

You can change the name if you want, but the default name captures both the name of the original database file and the date that you make the backup.

Tip: When you restore data or objects from a backup, you want to know which database the backup came from and when the backup was made. Data recovery android app Therefore, it is usually a good idea to use the default file name.

A split database typically consists of two database files: a back-end database, which contains only data in tables, and a front-end database, which contains links to the tables in the back-end database, in addition to queries, forms, reports, and other database objects. Z a r data recovery All the data is stored in the back-end database. Database hacking All the user interface objects, such as queries, forms, and reports, are kept in the front-end database.

When you back up a split database, you back up the front-end and back-end databases independently of each other. Data recovery las vegas It is more important to make regular backups of the back-end database, because it contains your data. Data recovery micro sd You can make a backup of the front-end database whenever you change its design. A database is a collection of integrated and related However, because each user has an individual copy of the front-end database and can make arbitrary design changes, you should also consider requiring those users to make their own backups of the front-end database. Database backend Back up the back-end database

Because running the backup requires exclusive access to the database file, users may be momentarily unable to use the back-end database. Gpu z database You should consider notifying users before you start the backup process.

In the Save As dialog box, in the File Name box, review the default name for your database backup. Data recovery for android You can change the name if you want, but note that the default name captures both the name of the original database file and the date that you make the backup.

Tip: When you restore data or objects from a backup, you need to know which database the backup came from and when the backup was made, so using the default file name is usually a good idea.

To protect your investment in the design of your front-end database, you should back up the front-end database whenever you change its design. Database types If you allow users to customize the design of their own copies of the front-end database, you should consider requiring them to back up their own customized copies.

To back up the front-end database, leave the database open immediately after you change its design. Data recovery center Then follow the steps in the section Back up a database, starting at step 2.

banner