Solved: database bloats on table copy

[Van Ieperen]

Hello,

I wrote a piece of code where a parameter list is read from a txt file and placed in a table.

For table manipulation purposes, I copy this table in another temp table with the SELECT function. The only "odd" thing is that I use
" & txtbox input & " to indentify the table name in the code.

Exactly when the DoCmd is executed, the database bloats by 7 MB.:banghead:

Can anybody give me any advise where to look???

(field names are txt, unicode compression set to YES in both tables.)

Thanks a lot..

[Van Ieperen]

Haven't found the problem yet, but the bloating is not caused with the copying of the table.........