Parameter query, prompt for tablename

K

KarenH

Is there a way to create a stored make-table query in Access that will prompt
the user for the name of the table, without writing code in a module, just
within a stored Access query?

TIA
 
M

MGFoster

KarenH said:
Is there a way to create a stored make-table query in Access that will prompt
the user for the name of the table, without writing code in a module, just
within a stored Access query?
Click to expand...

It can't be done in a QueryDef. You have to use VBA to dynamically
create the SQL string.
 
Top