Computer bloat question

[Salad]

I'm sure there are causes for computer bloat. I've wondered if it came
from running queries. I have lots of queries that are created within my
forms, sometimes reports and modules. Are these the culprits? How
about if you had a query that you constantly changed the SQL? Or is it
caused simply by the use of adding/deleting/modifying the records.

[streamline1000@gmail.com]

Re: Computer bloat question

The majority of Access bloat is not b/c of adding data to tables or
running queries, it is a result of just running and/or changing things
within your db like forms, reports, and other programming objects.
Right click your db, select Properties, and mark how big in MBs it is.
Then open your db and choose Tools -> Database Utilities -> Compact and
Repair Database. Now close it and recheck the size. Mine went from
12.3MB to 2.1MB the first time I used it.
Streamline1000

Salad wrote:[color=blue]
> I'm sure there are causes for computer bloat. I've wondered if it[/color]
came[color=blue]
> from running queries. I have lots of queries that are created within[/color]
my[color=blue]
> forms, sometimes reports and modules. Are these the culprits? How
> about if you had a query that you constantly changed the SQL? Or is[/color]
it[color=blue]
> caused simply by the use of adding/deleting/modifying the records.[/color]

[Salad]

Re: Computer bloat question

Chuck Grimsby wrote:[color=blue]
> On Wed, 02 Feb 2005 21:16:34 GMT, Salad <oil@vinegar.co m> wrote:
>[color=green]
>>I'm sure there are causes for computer bloat. I've wondered if it came[/color]
>[color=green]
>>from running queries. I have lots of queries that are created within my[/color]
>[color=green]
>>forms, sometimes reports and modules. Are these the culprits? How
>>about if you had a query that you constantly changed the SQL? Or is it
>>caused simply by the use of adding/deleting/modifying the records.[/color]
>
>
> Yes, Yes, Yes, and Yes.
>
> Compacting (as suggested by streamline1000@ gmail.com) only gets rid of
> the "bloat" (which is, in reality, "Working Space" for JET) until the
> next time you run the query that needed the space. Of course, that
> means that Access will have to stop to expand the MDB file, negating
> all that time you spent doing the "Compact and Repair".
>
> A properly developed Access database doesn't need to be compacted. I
> have several that haven't had that operation run on them for several
> years.
>[/color]

So what is a properly developed database? One that uses queries listed
under the query tab only? I have a few crosstab reports crosstab, that
I need to generate new recordsources. Also my forms are constantly
creating dynamic queries and I would not want to get rid of them and
only use those queries under the query tab.