Jim Hewson
jm.hwsn at gmail.com
Tue Mar 5 08:33:17 CST 2013
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?