Temporary tables in MS Access

[cuffash]

is it possible to make a temporary table in access?
and if so use as normal table for query comparison?

 

[PHV]

Use a MakeTable query:
SELECT ... INTO myTempTable FROM ... WHERE ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[addy]

What are you using the table for?

In soe of my databases, I use temporary tables where I create a table, populate it, use it and delete it and in some cases, I use a Recordset.

It depends on what I need to do.

 

[dhookom]

There is no such thing as a "temporary table" in Access (unlike SQL Server). Tables are tables are tables. You might create a table for temporary use but it is the same as any other table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MichaelRed]

" ... the same as any other table ... "

Including the ubiquitous bloat issue re ALL .mdb files. NOTHING is ever really deleted until compact & repair is performed.




MichaelRed