Re: Unusual FE bloating
- From: "FPS, Romney" <fpswv@xxxxxxxxxxx>
- Date: Wed, 2 Dec 2009 09:17:33 -0500
Ok, the problem (if it is a problem) is that Access 2007 must do something
very different than earlier versions. I checked one of the other FE's being
run under 2007 -- different user -- and it also has increased in size
dramatically compared to the same version 2000 FE being run under Access
2002. Over the same period of time, and doing essentially the same
operations, the FE being run under 2002 increased from 10,984 kb to 13,628
kb. That same FE when run under 2007, increased from 10,984 kb to 138,000
kb.
Still haven't had a chance to step-through different processes to see if
there's a particular operation that gets handled differently by 2007
compared to earlier versions.
Mark
"FPS, Romney" <fpswv@xxxxxxxxxxx> wrote in message
news:OweQY6faKHA.544@xxxxxxxxxxxxxxxxxxxxxxx
The frontend I distribute is subject to a certain amount of bloating due(I
guess) to a few temp tables that are emptied and filled as needed for somemay
reports. The compacted FE is approx. 11,000 kb. Through normal use this
increase to about 12 or maybe even 13,000 kb. It usually doesn't increaseFE
much beyond this no matter how many more times the reports are generated.
There's a number of users with personal laptops with their own copy of the
FE and their own local copy of the BE. They all show the normal amount of
bloating noted above, except for one user whose FE typically is aroundrunning
128,000 kb whenever I get a chance to look at it every week or so. The BE
appears as expected in terms of size.
The user says (of course) that they don't do anything unusual and deny any
operational problems or error messages. The FE is Access ver. 2000,
under Access 2007. Other users with this same configuration don't showthis
unusual FE bloating -- at least 10 times the expected amount.
Any ideas as to what might cause this kind of excessive bloating?
Thanks,
Mark
.
- Prev by Date: Re: Problems using Access 2007 for 2003 format db
- Next by Date: Re: Problems using Access 2007 for 2003 format db
- Previous by thread: product key
- Next by thread: Password Help
- Index(es):
Relevant Pages
|
