use temporary table in access

T

tonyqus

how to use temporary table in access like that in SQL Server? Is any
limitation in it?
 
R

Roger Carlson

Access does not have a temporary table in the sense the SQL Server does.
You can create a regular table temporarily (either by Select...Into or SQL
DDL statement or by VBA code) and then delete it when you are done.
However, this causes bloat in the database. I have worked around this by
programmatically creating a temporary *database*, export (or create) a table
there, link it back to the original database, then destroy the whole temp
database when I'm done.

On my website is a small sample database called: "ImportToTempDatabase.mdb"
which uses a temp database and table for importing.
 
W

Wayne Morgan

I'm not sure how they compare to SQL Server, but you can create tables in
Access and use them as temporary tables. They are subject to the same
limitations as any other table. The main problem with them is that they will
cause your file to "bloat" in size. Tony Toews has some tips on handling
this.

http://www.granite.ab.ca/access/temptables.htm
 
Top