A few days ago, I asked "is there a way to create a new table in a Access

database from an ASP application?"



Many thanks to Scott Munro, Robert Chartier and Jason A Greenfeld for

replying.  The way I finished up doing it is to copy all fields from a

template table into the new table. The SQL command below does the job.



	SELECT TemplateTable.* INTO NewTableName FROM TemplateTable



Thanks again



John Lewis