jwcolby
jwcolby at colbyconsulting.com
Fri Apr 29 12:17:53 CDT 2011
Well... I haven't managed to address this yet. The last few days were pure overload. John W. Colby www.ColbyConsulting.com On 4/29/2011 12:57 PM, Dan Waters wrote: > John - how did it go? > > Dan > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Tuesday, April 26, 2011 9:59 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access 2003 - 50 meg FE > > 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 >> >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >