jack drawbridge
jackandpat.d at gmail.com
Tue Mar 5 08:42:12 CST 2013
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 >