Thanks for very prompt replies. I now have a printout of adovbs.inc.



However I still don't know whether it is possible to run Access 2000 'make

table' queries. Presumably CommandType has to be adCmdStoredProc for an

Access Query. Somehow it is necessary to tell the server its OK to overwrite

the existing table.



Regards



Tony Blackman

Tel (01404) 45982

Fax (01404) 46600

email tonyblac@n...



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

From: Ken Schaefer 

Sent: 17 June 2000 15:07

To: ASP Databases

Subject: [asp_databases] Re: Access Query Types







> My other problem which may be associated with the above is that I cannot

> find anywhere a list of the options for objCommand.CommandType. WROX says

> use adCmdTable and another book says use 4; both seems to work but what

are

> the full list of options?



Never use "magic numbers" like 4 - it's too hard to debug in the future.



To find a list of all the ADO constants, do a search for the file adovbs.inc

on your computer and have a look in that.



Cheers

Ken

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



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

From: "Tony Blackman" 

To: "ASP Databases" <asp_databases@p...>

Sent: Sunday, June 18, 2000 8:38 PM

Subject: [asp_databases] Access Query Types/2





> Thanks for very prompt replies. I now have a printout of adovbs.inc.

>

> However I still don't know whether it is possible to run Access 2000 'make

> table' queries. Presumably CommandType has to be adCmdStoredProc for an

> Access Query. Somehow it is necessary to tell the server its OK to

overwrite

> the existing table.

>

> Regards

>

> Tony Blackman

> Tel (01404) 45982

> Fax (01404) 46600

> email tonyblac@n...

>

> -----Original Message-----

> From: Ken Schaefer

> Sent: 17 June 2000 15:07

> To: ASP Databases

> Subject: [asp_databases] Re: Access Query Types

>

>

>

> > My other problem which may be associated with the above is that I cannot

> > find anywhere a list of the options for objCommand.CommandType. WROX

says

> > use adCmdTable and another book says use 4; both seems to work but what

> are

> > the full list of options?

>

> Never use "magic numbers" like 4 - it's too hard to debug in the future.

>

> To find a list of all the ADO constants, do a search for the file

adovbs.inc

> on your computer and have a look in that.

>

> Cheers

> Ken

>