Re: Stubborn front-end bloat in Access 2002
- From: Steve Jorgensen <nospam@xxxxxxxxxxxxx>
- Date: Tue, 29 Nov 2005 19:21:53 -0800
Just an update...
The client opened the database in Access 2003, ran repair & compact, and it
shrunk right down to 1/3 of its previous size. Worst case, if it resumes
bloating again, I'll just have the client compact it for me every few months
or upgrade my Access to 2003.
On Tue, 29 Nov 2005 01:35:12 -0800, Steve Jorgensen <nospam@xxxxxxxxxxxxx>
wrote:
>I'm working on an application in Access 2002, and every time I'm done making
>changes in the VBA project, the database is noticeably larger after
>compacting, even when code changes are small or even if they involve removing
>more code than I add.
>
>In the past, I've usually been able to recover space in these situations by
>decompiling the front-end, but in this case, after I decompile, compact,
>recompile, and compact again, the database has bloated even larger. The
>database is now over half again the size it was a few months ago, and the
>added content over that time probably represents about a 2 or 3% increase.
>
>Any ideas?
.
- References:
- Stubborn front-end bloat in Access 2002
- From: Steve Jorgensen
- Stubborn front-end bloat in Access 2002
- Prev by Date: Re: Access 12 RAD strategies
- Next by Date: Re: Single item inventory?
- Previous by thread: Re: Stubborn front-end bloat in Access 2002
- Next by thread: Query to ignore other conditions
- Index(es):
Relevant Pages
|