The reason to that is the following:
Each time a record is inserted Jet engine uses the
next free memory page going on and by blocks of
at least 2Kbytes even if the logical record length is lower than that.
The update of a record is not a REAL update: it is a combined
operation made of a deletion of the old record with the
subsequent reinsertion of the new data. Used pages
of memory are never reused, even if they contain no valid
data, until you perform a Compact Database Action.
For what concerns integrity problem you must
specify if you intend the database curruption (it's
no more accessible ) or something related to data
integrity such as key references violated.
--
Andrea Lanfranchi
My Software Never Has Bugs
It Only Develops Random Features
-------------------------------------------------------------------------
Please remove "nospam" from my address if you
want to reply.
Quote:> I have developed a package with an Access 97 backend. The package sees
alot
> of use taking about 500 new records in 16 hours with each recorded be
edited
> at least three times in that period. The problem is that the size of the
> database grows very large very quickly and I am not sure why but it is
> causing integrity problems. For example: the database was about 300k at
the
> beginning of the day (8am). By 4pm the database was 12Meg. At that time
I
> shut down the program and did a compact and repair on the database and the
> size went down to about 400k.
> Thanks.