You can choose to compact a database to get a smaller file size by manually compacting the database or by setting it to happen every time the database is closed. In this tutorial, you will learn how to compact a database in Access 2007.
Thanks a lot! My database went from 8 mb to, no joke, 126 mb and I hadn’t hardly added much to it. I was just running some macros and vba scripts that I wrote to change and format the data that was being merged from an older database. Now it is down to 6.5 mb!
Thanks, all I had to do was look at the picture to find the answer.
Thanks it is helpfule
Thanks a lot! My database went from 8 mb to, no joke, 126 mb and I hadn’t hardly added much to it. I was just running some macros and vba scripts that I wrote to change and format the data that was being merged from an older database. Now it is down to 6.5 mb!