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