-
Solved: database bloats on table filling
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.
Can somebody give me some advise??
Thanks a lot...
-
Hello, do you get the same amount of Bloat if you just use an Update Query?
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules