Database Size grows Exponentially

[Margie]

I have a table with approx 1 million records which, after
compression, is about 500,000 KB in size. While running
some data manipulations using a recordset (I'm not adding
any fields, just adding data to a field), the database
grows to maximum size and won't complete the operation.
Any idea why the database grows so big? FYI: I"m able to
perform data manipulations using queries, but not
recordsets. THANKS

 

[Wayne Morgan]

Without knowing what you're doing, it is hard to tell. Depending on the
manipulations, Access or you may be creating temp tables that are causing
bloat. If you are inserting pictures, there may be a better way. The two
links below will deal with bloat.

http://www.granite.ab.ca/access/bloatfe.htm
http://www.granite.ab.ca/access/imagehandling.htm

Also, you may need to split your tables into more than one mdb file and link
to them from a "front-end" file.

 

[John Vinson]

I have a table with approx 1 million records which, after
compression, is about 500,000 KB in size. While running
some data manipulations using a recordset (I'm not adding
any fields, just adding data to a field), the database
grows to maximum size and won't complete the operation.
Any idea why the database grows so big? FYI: I"m able to
perform data manipulations using queries, but not
recordsets. THANKS

I believe that when you edit data in code, Access creates the new
record on disk in addition to keeping the old record. An Update query
is more efficient.