I have a simple database that stores and retrieve data, driven by forms, controls, queries etc. Each time I run the application the file size of the database gradually increases. Why is this, and how can I prevent it from happening?
Currently, everytime I exit from the database, I have to manually do a ‘compact and repair database’ from the Database Utilities options in the Tools menu.
