[AccessD] Access 2003 - 50 meg FE

jwcolby jwcolby at colbyconsulting.com
Tue Apr 26 21:59:24 CDT 2011


sure.


John W. Colby
www.ColbyConsulting.com

On 4/26/2011 1:53 PM, Dan Waters wrote:
> 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