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