I have a shared Access mdb that was originally written in A2000. The
database is large, around 40 tables, 40 forms (many with multiple
sub-forms), and 100s of re****ts. The database is not split, but runs off
of
the LAN in the office with about 5 or 6 concurrent users. Recently the
office upgraded to A2007 but they are continuing to run in compatability
mode.
The problem is that with ordinary use, read/write operations through the
user forms only, the database quickly bloats from about 60Mb to over
200Mb.
There are no im****t/ex****t actions, no make-table queries, nothing like
that
in ordinary use. Compacting and Repairing the mdb from A2007 doesn't
shrink
the mdb appreciably in size, but if I open the file with A2003 and compact
and repair it shrinks back down to 60Mb again.
The only wrinkle I can throw into the mix is that one of the users is
using
Vista while the rest of the users are on XPpro. I tried to lock the Vista
user out of the db for a day to see if that affected the problem, and the
results are mixed. In the following 2 hours I didn't see the db grow much
in size, although it did grow from 60Mb to about 70Mb. In the next 2
hours,
when I wasn't watching to make sure no one accessed the db from the Vista
machine it grew to over 200Mb again.
Anyone have any ideas?
|
