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 > >