File Growing From Query & Subforms

[matethreat]

Hello,

I have a database with only 3 tables and from those 3 tables I use queries to gather other information and display that information between Subforms and Reports (But not to create or append tables, just for viewing purposes). My question is even though no additional data is being entered in the tables the file size of my database grows from those queries, is that normal, or is there a way of stopping that from happening.

Thanks

 

[BobAtHome]

Yes, unfortunately, that is normal. To get the size of your database down, you need to compact it ever so often. Use menu options "Tools/Database Utilities/Compact and Repair Database" and select your database to compact.