Access has filters, which are SQL commands that you store. You can then
slice them and dice them just like a "real" table. You aren't having to
recreate the temp table every time the database starts. Access, however,
is not a real production database built to be hit on by a lot of people. I
think it's most productively used around the world on downloaded data for
creating reports on "dead" data.
Ike
At 12:07 PM 7/9/01 -0400, you wrote:
> >Do other database systems sport temp tables?<
>
>SQL Server has temporary tables. If you precede the
>table name in the 'create table' syntax with a '#', then
>it is created as a temporary table. Also temp views.
>
>
>
>Karen
