You will see very noticeable bloating but probably little effect on
performance.
A suggested way to do this to avoid the bloating problem is to create a
"template" external mdb file with all the tables you are now using as temp
tables. Make a copy of this file and put it in an appropriate folder. Link
to the tables in this file from your front end. Where you are filling your
temp tables now, change and fill the tables in the external mdb file. Where
you are deleting records in your temp tables, eliminate all deleting and
just use the Kill statement and delete the external file. Replace the
external file by copying the "template' file and naming the copy with the
name you chose for the external mdb file using the FileCopy command.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:2%******************@newssvr17.news.prodigy.c om...
An application that I develop uses a lot of temporary tables. I very
frequently empty the tables (using DELETE From), then fill them back up.
Anyone have comments on what effects I might expect to see on performance
and bloating by deleting the tables, then using SELECT INTO to recreate,
instead of the way I have been doing it?