Maketable query

P

PO

Hi

I have a web reporting application that uses an access db. Each time a user
requests data the report passes 1 parameter (wonum) and the query creates a
temporary table. How do I make sure that each temp table gets an unique
name?

i.e.
PARAMETERS [wonum] Text ( 7 );
SELECT
'02' AS CLIENT,
W.WONUM,
W.DESCRIPTION INTO temp
FROM
WORKORDER as W
WHERE
W.WONUM=[wonum] OR W.PARENT=[wonum];

In the above example a temp-table is created, but what if 2 users run the
same query at the same time? Is it possible to use a parameter for the name
of the output-table?

TIA
PO
 
S

Steve

Hello,

I need to also set up a web reporting application that uses an access db.
Can you give me some details about how you set yours up on the web. Do you
update the data in the database?

Thanks!

Steve
 
Top