A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Severe bloating of Frontend DB with Access2007



 
 
Thread Tools Display Modes
  #1  
Old October 28th, 2008, 09:21 PM posted to microsoft.public.access
Mark Liquorman
external usenet poster
 
Posts: 4
Default Severe bloating of Frontend DB with Access2007

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.


  #2  
Old October 28th, 2008, 09:43 PM posted to microsoft.public.access
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Severe bloating of Frontend DB with Access2007

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
--
KARL DEWEY
Build a little - Test a little


"Mark Liquorman" wrote:

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.


  #3  
Old October 29th, 2008, 12:50 AM posted to microsoft.public.access
Mark Liquorman
external usenet poster
 
Posts: 4
Default Severe bloating of Frontend DB with Access2007



"KARL DEWEY" wrote:

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.
  #4  
Old October 29th, 2008, 02:30 AM posted to microsoft.public.access
AccessVandal via AccessMonster.com
external usenet poster
 
Posts: 461
Default Severe bloating of Frontend DB with Access2007

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

Second, are there any virus,trojans,spywares?

Scan the harddisk for errors, if possible scan the RAM memory modules for
error with memtest utillities. They are avialable free from the internet
sites.

Mark Liquorman wrote:
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.


--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

  #5  
Old October 29th, 2008, 02:44 AM posted to microsoft.public.access
Mark Liquorman
external usenet poster
 
Posts: 4
Default Severe bloating of Frontend DB with Access2007

"AccessVandal via AccessMonster.com" wrote:

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.
  #6  
Old October 29th, 2008, 03:09 AM posted to microsoft.public.access
AccessVandal via AccessMonster.com
external usenet poster
 
Posts: 461
Default Severe bloating of Frontend DB with Access2007

Note that not all virus,trojan,spywares can be detected.

Have you verify that the harddisk and memory are free from defects? Although
power supply might be the culprit, but I doubt so.

If is not a commonality, have you tried reinstalling Access or MS Office
again? Or even reinstalling the OS and MS Office/Access again?

Mark Liquorman wrote:
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.


--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

  #7  
Old October 29th, 2008, 03:26 AM posted to microsoft.public.access
Mark Liquorman
external usenet poster
 
Posts: 4
Default Severe bloating of Frontend DB with Access2007

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.
  #8  
Old October 29th, 2008, 08:03 AM posted to microsoft.public.access
AccessVandal via AccessMonster.com
external usenet poster
 
Posts: 461
Default Severe bloating of Frontend DB with Access2007

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


As above, is bloating from 2003 format or 2007?

So far, I only have use 2000 and 2002/XP format in 2007 development. Nothing
on bloating.
There of course, annoyances and inconsistancies but all could be solve by
changing the format to 2007 accdb without any coding change or modifying of
objects.

You might want to try converting it to a 2007 format accdb than do a compact
and repair under 2007 before importing the objects. I have yet to try to
import objects like you did, but least it works for me.

Will try to use A2003 if I have the time.

Mark Liquorman wrote:
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.


--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

  #9  
Old October 30th, 2008, 02:28 AM posted to microsoft.public.access
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Severe bloating of Frontend DB with Access2007

Mark Liquorman wrote:

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/
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.