Issues with an .mde file

[Guest]

I have a database created in access 2000 that i am currently using in 2003 as
an mde file. when i enter data through the forms the size of the file
appears to grow at an immense rate. the size problem can be overcome by auto
compacting the file on close but I would prefer to find the root cause of the
problem.

I have changed the orignal mbd file to access 2003 and then reconverted it
into an mde but the file size continues to grow.


I welcome any advice that you may have
Paul

 

[Guest]

What do you mean by "immense rate"? How big does it get?

Access requires internal temporay space to do things like sorting and
grouping records in queries, forms, and reports. A compact and repair gets
rid of this temp space. However the first time that you run the same queries,
forms, and reports, the database grows again. If you do another compact and
repair, it soon gets to be like a dog chasing it's tail.

If a compact and repair only reduces the file size by less than 20 mb or so,
I wouldn't worry about it.

Now if you are creating temporary tables or have tables where you often
delete records then refill the table, that can cause bloat.

 

[artisti]

Take a look to this website!
http://www.aveit.it

New italian musical label!


Il 16-10-2007 21:38, nell'articolo
(e-mail address removed), "Sasquatch UK"

 

[Guest]

Thanks for the assistance so far Jerry...

The database starts off at roughly 1.5Mbs. When I change / enter a few
lines of data i.e. components of a single record the database appears to grow
by 500kbs whenever I exit. When I do large changes the file has grown in
excess of 35Mbs. I do have a macro that operates in the background running a
number of queries to ensure what is displayed on the screen of my form is the
most up to date information regards progress 'traffic lights' etc. As far as
I am aware the macro is not purposely creating temporary tables as it
directly manipulates specific tables.

As you say we have managed to get into a circular process which can be
overcome but not stopped by the compact and repair function. The strange
thing is that this size increase does not happen when I am using the original
or 2003 mdb version of the file.


I hope this clarifies some things
Paul