What is a Temp Table?

[gunny3000]

I have read on many forum pages that Temp Tables cure some errors pertaining to common errors for split DB's (too many records open... or something like that).

I have not yet split my DB, but, it would be better if I could.

My DB is not large and I do not have many Queries (or Tables).

I appreciate Temp Tables are frowned upon, but, I have limited resources to make this DB bullet-proof. But, I do ot even know how to make a Temp Table.

 

[MStef]

The "Temp" table is a TEMPORARILY table. I use this table in
the MAKE TABLE QUERY. When (in VBA) I run a make table query,
it make a Temp table (with some data), which I use in next step
in VBA.

 

[Guus2005]

First i'd recommend that you split your database using the provided wizard for that purpose.

Access:
A temp table is a regular table created on-the-fly stored in the frontend or the backend. It is the place where temporary records are stored. Usually to delete the table afterwards.

SQL Server
A temp table (@Temp) is a table stored in the Temp database. Usually create on-the-fly and deleted by hand or SQL Server.
A temp table (@@Temp) is a table stored in active memory. Usually created on-the-fly and for small recordsets since it is created in active memory.

Enjoy!