Jim Dettman
jimdettman at verizon.net
Tue Mar 5 09:37:08 CST 2013
Sounds like the VBA project was out of whack... Did you do a /decompile at any point or import into a fresh DB container? If so, all the compiled pseudo code was dumped. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Tuesday, March 05, 2013 09:33 AM To: Access Developers discussion and problem solving Subject: [AccessD] Access 2007 - compacted 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