Question Why is my mdb growing?

[georgeburns]

I have a MS Access 2003 format mdb which I run under 2007 or office xp.

There are four forms which are slightly different from each other linked from the main switch board. Their activate and on load events are exactly the same as each other. When I open one of the four forms from the switchboard,... the database grows. The other three have no effect on the database size.

Why would one form with no different form events change the database size when the other three forms have no effect at all?

 

[maxmangion]

try to "compact and repair" your database which you may access from Tools -> Database Utilities.

Alternatively you may create a new database and import all of your objects (i.e. tables, queries, forms etc) to the new database and see if issue persists.

 

[boblarson]

I have a MS Access 2003 format mdb which I run under 2007 or office xp.

There are four forms which are slightly different from each other linked from the main switch board. Their activate and on load events are exactly the same as each other. When I open one of the four forms from the switchboard,... the database grows. The other three have no effect on the database size.

Why would one form with no different form events change the database size when the other three forms have no effect at all?

What differences in record source are there?