Database Expanding out of Norm

  • Thread starter Thread starter gbregar
  • Start date Start date
G

gbregar

I am working with a relatively small DB (about 9MB when compacted). It is
shared amongst 40 users but not all at once. I have noticed that the
database grows in size at the rate of about 30kb every 15 seconds or so. I
have never seen this before. I know it will grow, but this expands to about
250MB per day. Here is what I've checked/done:
*Problem happens even with just me in DB, *Problem happens when no forms or
reports open and no active code running, *DB has a backend DB but have tested
it in both ways with same results, *Have moved it to another location on the
network and to the desktop with same result

I'm out of places to look...any suggestions?

Thanks,
Gary
 
Any chance you are storing pictures/images in it?

Which version of Access?

Do you have any Timer-based procedures?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
I am working with a relatively small DB (about 9MB when compacted). It is
shared amongst 40 users but not all at once.
Click to expand...

Two users at the same time is one too many.
I have noticed that the
database grows in size at the rate of about 30kb every 15 seconds or so. I
have never seen this before. I know it will grow, but this expands to about
250MB per day.
Click to expand...

This is one of the symptoms of multiple users sharing the same database
frontend.
Here is what I've checked/done:
*Problem happens even with just me in DB, *Problem happens when no forms or
reports open and no active code running, *DB has a backend DB but have tested
it in both ways with same results, *Have moved it to another location on the
network and to the desktop with same result
Click to expand...

Give each user their OWN COPY of the frontend, all linked to the same backend.

If that's what you have please explain in more detial.
 
Also, tell us which version of Access and whether or not it has been patched
with the latest updates.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top