|
|
Set Up Your Access Database to Automatically Compact and
Repair
Worried about the increasing size of your
database? To ensure optimal performance, you should compact
and repair your Microsoft Access files regularly. On the
Tools menu, point to Database Utilities, and then
click Compact and Repair Database. But don't stop
there! Let Access do it for you automatically. How?
1.
Open the Access database or Access project that you want Access to
compact automatically.
2.
On the Tools menu, click Options.
3.
Click the General tab.
4.
Select the Compact on Close check box.
|
|