![]() ![]() For example, you can restore a database from a copy that is stored on a USB external backup device. You should use the Back Up Database command in Access to make backups, but you can use any known good copy to restore a database. Note: You can only restore a database if you have a backup copy of the database.Ī backup is considered a "known good copy" of a database file-a copy of which you are confident of its data integrity and design. 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. In the Save As dialog box, in the File name box, review the name for your database backup. Under Advanced, click Back Up Database, and then click Save As. Under File Types, click Save Database As. ![]() To open only the back-end database, start Access.Ĭlick Open Other Files > Computer > Browse, and then select the back-end database file that you want to back up.Ĭlick the arrow next to Open, and then click Open Exclusive. Notify users before you start the backup process because running the backup process requires exclusive access to the database file, and users might be unable to use the back-end database while the backup process is running. Individual users of the front-end database can make arbitrary design changes, so consider requiring the users to make their own backup copies of the front-end database. Make a backup of the front-end database when you change its design. Because the back-end database contains the data, it is more important to make regular backups of the back-end database. All the user interface objects, such as queries, forms, and reports, are kept in the front-end database.īacking up the front-end and back-end databases independent of one another as you must do with a split database can be time consuming. All the data is stored in the back-end database. Select the file type you want the backup database to be saved as from the Save as type list, and then click Save.Ī 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, queries, forms, reports, and other database objects. Tip: When you restore data or objects from a backup, you usually want to know which database the backup came from and when the backup was created, so it’s good practice to use the default file name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |