File Size Grows When Opening or Closing a Form In Access 2007

[JCS]

Hello Everyone,

I'm using Access 2007. When I open or close a form the size of my database
grows by 4kb. This also occurs when the form is closed. I tried compacting
the database but does nor work. Has anyone seen this and if so, is there a
fix?

Many thanks in advance!
John

 

[Jerry Whittle]

An Access database file can be 2GB in size; therefore, 4KB is a drop in the
bucket. Actually I'm surprised that in only grows that much.

Access needs some elbow room to do its stuff. If you run a query that sorts
data, it needs to hold that data somewhere. Therefore there are some unseen
temp spaces within the file. Usually a Compact and Repair will reclaim that
space; however, the next time you run the query, Access will again expand.
Therefore it isn't worth doing it.

Is it possible that your form is adding data to a table when it opens or
closes?

I'm thinking that the 4K may have something to do with the operating system
disk block size.

 

[Klatuu]

Is this occurring in design view or in production?

It is not unusual for a database file to get larger with use. It is called
Bloating. There are several possilbe reasons for this. In design view, it
will just about always happen. In production, it can happen depending on
what you are doing. If your database is not split and you add and delete
records, run queries, etc., there are "empty spaces" in the file. A Compact
should reduce it down to its mimimum size.