Dan Waters
df.waters at comcast.net
Fri Apr 29 11:57:50 CDT 2011
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