[AccessD] Access 2003 - 50 meg FE

Dan Waters df.waters at comcast.net
Tue Apr 26 12:53:46 CDT 2011


John,

I made and have been testing an essentially one-click access utility which
will do export to text and import from text of all the objects except
tables.  Do you want to try it?

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, April 26, 2011 11:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
--
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