I have heard of this happening with jet 3.5 (Access97) but aparently it was
not like this with jet 3.0 (Access95).
I am very keen to know also why this is happening and if there is a
solution.
Also, what about jet 4 (Access2000), how will this perform??
>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.