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.