It's working the same concept as a hard disk store and delete files.
On a hard disk when you create a file it save on an empty space and
create a pointer to the file in the ntfs table (wich is like a list of
all file where they are exaclty on the hard drive, a mega group of
pointer to eahc file and folder). Access work same no exception, but
all access object (table,forms, report...) are consider files and the
base of access consider it as the ntfs table.
So what happen when you delete a file on your hard drive ???
answer : it never get deleted it
Yes as i said file is not deleted, only the pointer in the table is.
Due that windows work thought file with that table he wont show the
file that was there.
Access is always the same, if you delete the form it only delete his
"pointer to it" and all code in it. exception of object. so that why
the file doesnt change size if you delete a form. because form use
more space than tables most of the time, but tables does the same
thing it's just not as visible as forms or report ...
so if you keep delete and create forms for example he gonna keep
create (take space) and delete (remove pointer but space still used).
That's why compact database exist, it re-allocate all byte of USED
data. Said so it mean un-used (deleted things) aren't taken in the new
construction and it can shrink alot a database.
It appear more in access 2007 because the forms can do more stuff than
older access version so they are more heavy that's why it appear
growing faster.
once it got compact if you change nothing it wont grow that much,
unless somewhere you havequeries that wipe out whole table data and
create new full tables, but like i said table take need to enter ALOT
of data to really growth.
