| Alex White MCDBA MCSE 2005-05-19, 7:24 am |
| Yes you use server side temp tables look in the SQL books online for help,
also you can create the #temp tables so that individual users cannot see
other peoples #temp tables.
but to get the best from a temp table on the server you should populate them
from stored procedures on the server as everything is them running locally,
the speed improvement is substantial.
--
Regards
Alex White MCDBA MCSE
http://www.intralan.co.uk
"Jonathan Crawford" <jc@jcrawford.co.uk> wrote in message
news:OqIPwNEXFHA.2684@TK2MSFTNGP09.phx.gbl...
> Hi
>
> I am used to using local temp tables in and mdb file to speed up
> some functions.
>
> How would this work with an adp file where the temp table is created
> on the server? What would happen if two people used the same table?
>
> thanks
>
> jonathan
>
> --
>
> ===============
> Jonathan Crawford
> 01273 440018
> 07799 068570
> fax 01273 380221
> jc@jcrawford.co.uk
> ===============
>
>
|