[AccessD] Access 2003 - 50 meg FE

Rocky Smolin rockysmolin at bchacc.com
Tue Apr 26 08:24:53 CDT 2011


Data in temp tables?  

Otherwise although a PITA, binary search.  Import half the objects, see what
the size is after C/R.  Import half the remaining, etc.  Eventually, you'll
find the culprit.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, April 26, 2011 5:47 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2003 - 50 meg FE

I have a very simple FE, 20 linked tables (to SQL Server), 10 forms, 1
report, a handful of classes and modules.

The bugger is 50 megs and won't shrink down when I compact / repair.  It
should probably be a couple of megs.

Has anyone run across anything I should be looking at?

--
John W. Colby
www.ColbyConsulting.com
--
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