Stuart McLachlan
stuart at lexacorp.com.pg
Tue Mar 5 15:06:42 CST 2013
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 >