Re: Access Size Problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Nikos Yannacopoulos (nyannacoREMOVETHISBIT_at_in.gr)
Date: 03/22/05 

Date: Tue, 22 Mar 2005 11:50:49 +0200

Roy,

"almost 1000 forms and reports" sounds like you are duplicating forms
and reports instead of parametrizing? If that's the case, this is where
I would start!

Nikos

Roy Goldhammer wrote:
> Thankes Albert
>
> The size of my mdb is even double 15 more then your database. And i do have
> almost 1000 forms and reports.
>
> the 180Mb is after compact.
>
> I've asked many times here before about using refarances in access and
> nobody answer about it
>
> Do you know about it something?
>
> "Albert D. Kallal" <PleaseNOOOsPAMMkallal@msn.com> wrote in message
> news:uqItGWkLFHA.4092@tk2msftngp13.phx.gbl...
>
>>Obviously, as you work during the day, you will frequently compact your
>>database.
>>
>>What is the size of your database after you do compact?
>>
>>(further, you don't have a bunch of screen background graphics etc thrown
>
> in
>
>>there..do you?).
>>
>>To give you an idea, here is a small application of mine, the numbers are:
>>
>>lines of code in Modules = 8654
>>Lines of code in forms = 16654
>>Lines of code in reports = 2385
>> ------------------
>>total lines of code = 27693
>>
>>number of Forms = 163
>>number of Reports = 77
>>number of tables (total) = 63
>>number of tables (user) = 54
>>number of modules = 23
>>number of Queries = 187
>>
>>The whole above application is LESS then 10 megs in size. And, for use by
>>users, after converting to mde, the size is only 6 megs.
>>
>>So, when you talk about 180 megs in size, either somting is wrong!!..or it
>>is big! So, do you numbers work abou to be about 20 times more then what I
>>got above (ie: in place of 162 forms, you would have 1000+ forms to get
>>somting in the 180 meg size).
>>
>>--
>>Albert D. Kallal (Access MVP)
>>Edmonton, Alberta Canada
>>pleaseNOOSpamKallal@msn.com
>>http://www.members.shaw.ca/AlbertKallal
>>
>>
>
>
>

Relevant Pages

  • Re: System slows to snail pace-Help!
    ... Event Source: Service Control Manager ... Error Reports do you have? ... To compact place the cursor on Local Folders and select File, ... the System and Application logs in Event Viewer for the last boot. ...
    (microsoft.public.windowsxp.general)
  • RE: Compact and Repair Alternative
    ... Server database, you can't avoid the DB bloat. ... SQLServer Reports to see if any off the self products come up that may work. ... usually have the Access file set to Compact & Repair on close but my issue is ...
    (microsoft.public.access.modulesdaovba)
  • Re: Reports and Quweeries
    ... Compact the database to get rid of this junk: ... > In my application I have to produce 5 different reports. ... > I created a query for the initial SubReport and the MainReport as well as ...
    (microsoft.public.access.reports)
  • Re: Last Modified Date
    ... modules and reports potentially have redundant code ... apply to queries or tables. ... On second thoughts when you compact a BE database, ... Is this an Access Compact or DBEngine compact, and if the former, ...
    (comp.databases.ms-access)
  • RE: Access 2007 - Problems with saving on 1 form
    ... Try doing a compact and repair. ... The button prints 2 reports. ... I closed out without saving and tried something as simple as moving ...
    (microsoft.public.access.forms)