Ken



Thanks once again for your help. Up to now I've just been calling up the

queries stored in the database which has the limitation I mentioned of not

executing a make table query. Consequently I've had to go to a special

naming convention to cater not only for security, but also for the type of

query so I know when to run a delete query first. I like your idea of

DeleteObject and I'm wondering whether I can take cognisance of the warning

message.



Anyway thanks again. It should be possible to sort something out.



Regards



Tony Blackman

Tel (01404) 45982

Fax (01404) 46600

email tonyblac@n...



-----Original Message-----

From: Ken Schaefer 

Sent: 19 June 2000 10:53

To: ASP Databases

Subject: [asp_databases] Re: Access Query Types/2





If you want to create a *new* table use the:



CREATE TABLE Jet SQL statement (look in Access Help for syntax)



If you want to *alter* an existing table, use the:



ALTER TABLE Jet SQL statement (again look in Access help).



If you want to overwrite an existing table, use the:



DeleteObject method



If you want to create a table using a query, you can do that also, look

under the

"Create a new table from the results of a query with a make-table query"

heading.



Cheers

Ken