I have a single user database that is open and I'm not doing anything, but I
see the size of the file growing about 8k bytes every 20 seconds or so. What
is the system doing? Thanks
I remembered seeing a thread about this very problem some time ago, and found
this post from Paul Shapiro:
<start quote>
If you're using Access 2007, there was a hotfix announcement that might
apply:
Issues fixed include:
.. You experience slower performance than you did in previous versions when
you share a database file over a network.
.. You may notice your database file increase in increments of 4 KB without
any user interaction when the database is open.
.. You may see a sub-form become blank after you set the main form's
recordset. You may also receive the following error: "Run-time error 2467 -
The expression you entered does not exist".
These fixes are available at
http://support.microsoft.com/kb/960307.
If the mdb that's growing is the front-end, does each user execute a local
copy rather than all users running the same shared copy? I setup a shortcut
that copies the front-end db from the server to the local workstation and
then runs that shortcut. So even if the front-end grows, the user starts
with a clean copy each time they run the application.
<end quote, thanks Paul>
