Compact Improvements
It is amazing how a feature so essential can be so often overlooked. So that you don’t have to rely on your memory, beginning with Access 2000, the user can choose the Compact on Close option.
After a typical Access session, which usually involves processes such as adding tables, deleting records, and so on, the database begins to grow in size, affecting the space it occupies on the disk. It is important to note that the space that deleted records, tables, or other objects occupied is not automatically made available for new objects. Compacting not only frees up the space for new objects, it makes the overall size of the database smaller. For this reason, you should always compact before zipping.
How often should you compact? ...
Get Access 2002 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
