[AccessD] Access 2007 - compacted

Nicholas Lee Nicholas at nagase.com.my
Tue Mar 5 23:45:45 CST 2013


Hi Stuart,
If you have time could you share more about the backend/ frontend
structure.

I'm very new to Access and very knee to learn this new trick (I heard it
once / twice during the learning of Access, however, I don't know it in
details).


Thanks in advance.


Nicholas

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Wednesday, 6 March, 2013 05:07
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 - compacted

Yep,  I'd go with garbage collection on edited forms & reports too.  

They can really cause bloat when you edit them a few time, especially if
you have things like 
embedded bitmap logos in them.

I've seem 10-fold bloat on a heavily modified application before C & R,
not just 3-4 fold.   

And Jim,   You don't necessarily have a  very "complex database" with 77
tables.   
You do appear to have a "complex application".

Your queries, forms, reports and modules not part of your "database",
they are your 
application    Just these objects  may be stored in the same physical
file by Access, doesn't 
make them part of a "database".

BTW, it sounds as though you have your application and database in the
same file - you may 
like to consider splitting it into a backend/frontend structure. It is
trivial to do with the 
database splitter and makes subsequent maintenance/updating far easier -
especially if it is 
or maybe multi-user.

-- 
Stuart


On 5 Mar 2013 at 9:42, jack drawbridge wrote:

> When was the last C&R done? Could just be garbage collection if it's
been a
> long time and there's been a lot of "development"  and/or temporary
tables
> etc.
> Just a quick thought until others respond....
> 
> On Tue, Mar 5, 2013 at 9:33 AM, Jim Hewson <jm.hwsn at gmail.com> wrote:
> 
> > I had something happen that I can't explain. I hope someone on this
list
> > could shed some light on it.
> >
> > I have a complex database, 77 tables (2 linked, 2 user system), 518
> > queries, 161 forms, 146 reports, 29 modules and 2 classes and
approximatel
> > 42,000 lines of code.
> >
> > While I was creating this database the size increased.  The latest
was over
> > 92 MB.
> > I was doing some trouble shooting because one query wasn't working
> > correctly with one of the linked tables.
> > I got an error message... stating it couldn't find a field in the
query and
> > then it shut down.
> > I reopened the database did the usual - compile, saved, etc. I fixed
the
> > error and then the issue went away.
> > Then I did a compact and repair.
> > Everything is working, all the code is there, it's as if nothing
happened.
> > Great! I'm back in business.
> >
> > I checked the size of the it's down to 22.3 MB! How can that happen?
- goes
> > from over 92 MB to 22.3 MB.
> > I'm happy the file size is down and everything works! It also seems
to work
> > faster.
> > I'm confused.
> >
> > Can that be explained?
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list