[AccessD] Access 2003 - 50 meg FE

John Bartow john at winhaven.net
Tue Apr 26 09:41:55 CDT 2011


First thing that comes to mind is an ole object - image or whatever in one
of the forms or report. Even jpegs seem to increase the size far too much if
one would accidently or otherwise paste a exe, dll, wmv or something into a
form I'd imagine it would get huge. Check the forms and reports over and
remove any ole objects or embedded images. Then decompile, compact, compile,
compact.

If that accomplishes nothing then I'd import it into a new db.

Best of luck, 
John B

BTW have you tried running Eatbloat on it?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, April 26, 2011 7: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