[AccessD] Access 2007 - compacted

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



More information about the AccessD mailing list