Temporary tables

[MDB]

Hi,



Does Access VBA support temporary tables?

So for example you can define a temporary table which is indexed and stored in memory and only accessible by the current user.

Thanks.

MDB

[June7]

I set up 'temp' tables in the frontend of a split project. Temporary meaning data is input to table and retained only for the duration of a process, then purged.

Can programmatically construct a table from scratch but why?

[RuralGuy]

I do the same but create a new db for the temp tables to avoid the bloat it causes. When done I just delete the Temp db.

[June7]

In my case the tables are permanent, it is the data that is temporary. Design is not changed, just records saved and deleted. The tables are not many so don't make the file that much larger. As for the amount of code, the difference is mine doesn't have code to build db in addition to saving the manipulated data.