Severe bloating of Frontend DB with Access2007

[Mark Liquorman]

We have encountered a problem in which a database is continually bloating
under Access2007. This has nothing to do with the contents of the db or any
of the usual suspects, because I can duplicate the problem with a database
that has nothing in it at all! The database increases in size 4K every 5
seconds. A 100MB database increases in size about 256K every 5 seconds. Yet
not everyone experiences the problem!

We have encountered conflicting stories from Microsoft as to whether or not
this is a known problem. In any event, there has been no clue given as to
the cause or a possible workaround.

Right now, the "solution" is to tell users to close (with compact/repair)
every hour! But since often the "user" may be an unattended workstation used
to scan members in and out, this isn't real practical.

 

[KARL DEWEY]

I found that using a switchboard just opening and closing forms increases the
size.

I use the compact on close.
Office Button
Current Database
Compact on Close

 

[Mark Liquorman]

I found that using a switchboard just opening and closing forms increases the
size.

Let me repeat. This bloating occurs in an empty database! No objects at
all. No tables, no queries, no forms, no reports, no modules.

 

[Mark Liquorman]

You may have some hardware issues that may not be Access?

Second, are there any virus,trojans,spywares?

We've got Norton Anti-virus installed on machine I was testing on, but we
also have bloating occuring at some client sites. I can't come up with a
commonality.

 

[Mark Liquorman]

There is too much evidence that it is an Access2007 problem.

It seems to affect databases orignally created by Access2003 (haven't tried
earlier versions). I can create a db in Access2007 and it won't bloat. If I
import objects from an Access2003 db, then bloating starts; even if I haven't
actually done anything, such as cause code to run, etc.

I've had one person from Microsoft say it was a recently reported bug and
will be fixed in SP2. But this was contradicted by another Microsoft person,
so I don't know.

 

[Tony Toews [MVP]]

We have encountered a problem in which a database is continually bloating
under Access2007. This has nothing to do with the contents of the db or any
of the usual suspects, because I can duplicate the problem with a database
that has nothing in it at all! The database increases in size 4K every 5
seconds. A 100MB database increases in size about 256K every 5 seconds. Yet
not everyone experiences the problem!

We have encountered conflicting stories from Microsoft as to whether or not
this is a known problem. In any event, there has been no clue given as to
the cause or a possible workaround.

I don't recall reading any similar problems in the newsgroups. I
certainly haven't seen that problem myself.

You mention Norton AntiVirus. Are these ACCDBs? Is Norton set to
ignore ACCDBs/MDBs/ACCDEs/MDEs?

Is this on one PC or multiple PCs?

There is a brand new hotfix out which mentions a performance problem.
That might make a difference. See a recent posting in my blog in my
sig below.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/