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.
2  1175 
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: 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.
Chuck Grimsby wrote: On Wed, 02 Feb 2005 21:16:34 GMT, Salad <oi*@vinegar.co m> wrote:
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.
Yes, Yes, Yes, and Yes.
Compacting (as suggested by st************@ 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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Salvador I. Ducros |
last post by:
Greetings all,
I was hoping someone might be able to point me in the right direction. I'm
currently
using std::vector to maintain several lists whose objects are of unrelated
types (classes).
I've seen mentioned here and there a technique that uses 'void *' and
something called
'template specialization' that would reduce the amount of code generated for
the
|
by: RainBow |
last post by:
Greetings!!
I introduced the so-called "thin-template" pattern for controlling the
code bloat caused due to template usage.
However, one of the functions in the template happens to be virtual as
well. To support thin-template, I need to make virtual function as
inline.
Now, I know that compiler would generate an out-of-line copy when it
|
by: Rick Collard |
last post by:
I have been experimenting with the new Printer object in Access 2002
and discovered some unexpected database bloat. Simply assigning the
same value to a property of a report's Printer object will cause the
database to grow. Here's my test code:
Public Sub ChangeReportSettings( _
sReport As String, _
sDeviceName As String, _
Optional nIterations As Long = 1)
|
by: Danny J. Lesandrini |
last post by:
I know this has been discussed before, as I've seen the Google posts,
but they all leave me with an unanswered question:
Does my DAO code executed in the front end cause the back end to bloat?
(May also substitute UPDATE and/or DELETE queries for DAO code.)
I was just brought on to a project with Access 97 where the all data is
kept on the server. It doubles in size each day, from 80 mb to 160 mb.
The data file contains only tables...
|
by: BillCo |
last post by:
I'm using a backend that's been around for years before I joined the
company. It kind of grew exponentially and has some design problems
including large unused tables some temporary tables. It compacts to
150Mb, but after a day it's up to 300Mb and it gros steadily from
there. I need to:
(a) reduce the size
(b) reduce the bloat factor
Apart from moving the temporary tables to front end (which can't
possibly account for all of the this...
| | |
by: MLH |
last post by:
I've read a number of posts over the years that dealt with
the issue of database bloat. I'm wondering if anyone has
determined exactly what information comprises the bloat
when it does occur. Has anyone ever looked into that
and arrived at a conclusion?
Part-2 of the question is "Under what circumstances does
MS Access database bloat occur and what can be done
to circumvent it?"
|
by: DFS |
last post by:
One of my systems grew exponentially - from 13mb to 43mb - after adding some
10 temp tables (with no data), a new form, and about a thousand lines of
code. The .mdb has mostly table links, lots of forms and queries, and a
good bit of code overall.
But 43mb is totally unreasonble. I can't figure out where the problem is
occurring. It was fine for a long time. I even created a new file and
imported the objects and it blew back up to...
|
by: Tony |
last post by:
How much bloat does the STL produce? Is it a good design
wrt code bloat? Do implementations vary much?
Tony
|
by: mirandacascade |
last post by:
Question toward the bottom of this post....background information
immediately below.
Access 97
SQL Server 2000
Please note: although the subject line uses the word 'bloat', this
post is NOT a "what can I do to prevent bloat?" inquiry. When I
searched the postings in this group for information about bloat, I
believe I gained a rudimentary understanding of some of the things
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
