Solved: database bloats on table filling

[Van Ieperen]

Hello,

I have a table containing 1600 records with 4 fields each.
The first two fields are empty at first, the 3rd contains a parameter name, the last field contains the value.

With a While - End loop, I write the same information to every 1st & 2nd field of every record.

For some reason, the database file grows 7 MB every time this loop is done.:banghead:

Can somebody give me some advise??

Thanks a lot...

[OBP]

Hello, do you get the same amount of Bloat if you just use an Update Query?

[Van Ieperen]

Just using an update query is not an option, I have to do the same manipulations on different tables.

But I found a solution for my problem on another forum, I am using a temporary table in my front end, this is not a good thing to do. Using a temp database and table works perfect.