[AccessD] Access 2003 - 50 meg FE

 >>> First thing that comes to mind is an ole object - image or whatever in one of the forms or report.

Hmm... I do have an activeX control for the IE object.


John W. Colby
www.ColbyConsulting.com

On 4/26/2011 10:41 AM, John Bartow wrote:
> 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
>