In the Database to Compact From dialog box, navigate to and double-click the database that you want to compact and repair. Select Database Tools > Compact and Repair Database. On the templates page, double-click Blank Database. Make sure no other users are currently using the database file. Use this procedure when you can't directly open an Access database.
Top of Page Manually compact and repair a database that is not open Select File > Info > Compact & Repair Database.Īccess creates a copy of the compacted and repaired database in the same location. Top of Page Manually compact and repair a database that you have open Under Application Options, select the Compact on Close check box.Ĭlose and reopen the database for the option to take effect. In the Access Options dialog box, select Current Database. In multiuser databases, you might not want to set this option, because it can momentarily disrupt database availability. Set this option separately for each database that you want to automatically compact and repair. Setting this option affects only the database that is currently open. You can select the Compact on Close database option if you want to automatically compact and repair a database when it closes. Top of Page Automatically compact and repair a database when it closes
Rebuild microsofr database utility office for mac 2017 windows#
For more information, see Changes to file sharing over a network in Windows 10. Get sufficient file permission to the database If you do not have sufficient permissions and you need to compact and repair a database, contact your system administrator for assistance. You can then make more precise estimates that give other users guidance on how long they should avoid using the database.
If you run compact and repair operations on a regular basis, keep a record of how long it takes. Tell users how long they must avoid using the database. For more information, see Open an existing Access database.
You should notify other users when you plan to run a compact and repair operation, so that they can avoid using the database during that time. Get exclusive access to the database A compact and repair operation requires exclusive access to the database file, because the operation may disrupt other users. For more information, see Protect data with backup and restore processes. In addition to your regular backup strategy, you should make a backup immediately before you use the Compact and Repair Database command. It is sometimes possible to recover this data from a backup. Make a backup of the database During the repair process, Access may truncate some data from tables that are damaged. Take the following actions before you begin a compact and repair operation: In addition, you can manually run the Compact and Repair Database command, when you have a database open, and on a database that is not open. A common practice is to automatically compact and repair a database when it closes. There are several approaches to compacting and repairing a database. Why you should compact and repair a database Compact and repair a corrupted database when Access prompts you Compact and repair a database that is not open Compact and repair a database that you have open Compact and repair a database when it closes Tip Splitting a database can help prevent the corruption of database files and limit the loss of data by keeping the data in a separate file that users do not access directly. The Compact and Repair Database command can also help improve performance of your database. The compact process does not compress your data - it makes your database file smaller by eliminating unused space. You can use the Compact and Repair Database command to prevent or fix these problems. They can also occasionally become corrupt or damaged. Lessĭatabase files can grow quickly as you use them, sometimes impeding performance. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.
0 kommentar(er)
