scalar email

Quick Tip: Automatically Compact Access Databases

Although it’s not likely that you’ll ever before hit the optimum Access data source size of 2GB, it’s still good to know that you can set your database to immediately small or diminish the data dimension. This is especially true for databases where you are including as well as removing a lot of data each time.

To allow the automated small, open your Access file and also go to Tools Options.

Select the General Tab and also place a checkmark in the box next to “Compact on Close”

That’s it! Currently each time the data source is opened it will automatically small the information when you close Access.

Leave a Reply

Need help with the Commons? Visit our
help page
Send us a message