Creating temporary tables

[elandro]

Is there any way to create a tmeporary table? I mean, just when the user is in the system (I'm working with access/asp) the table is created and when the user log out it's deleted.

 

[Dreamboat]

Yes. It's called a query.

 

[elandro]

That would be like....

 

[Calvin]

Yes, lookup creating and destoying TableDef's. But creating and destroying causes the mdb to inflate and requires repairing and compacting more often and increases the chances of becoming corrupted.

 

[elandro]

Yes, lookup creating and destoying TableDef's. But creating and destroying causes the mdb to inflate and requires repairing and compacting more often and increases the chances of becoming corrupted.

Thanks... I'll create and errase tables... It's easier.

 

[NewfieSarah]

so everyone is saying here, to use a temp query instead of a table. that would kind of make sence since a query is like a table. So How can I make a temp query??

 

[Argonak]

I have some cache tables that I treat as temporary tables and run a lock on to avoid more than one user attempting to load to the table at once. They're only used for the rare import from xls command, but I dont know how I would manage it with a query.