|
 |
asp_databases thread: Access Query Types
Message #1 by "Tony Blackman" <tonyblac@n...> on Sat, 17 Jun 2000 10:12:23 +0100
|
|
My current application uses Acess2000 queries. My problem is that I can run
'select queries' but not 'make table queries' without getting the warning
"Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Table 'aatestable' already exists
". I have worked around this problem by running 'delete queries' and then
'append queries' but this is very clumsy and causing other problems. Is
there a way of running an Access make table query which means presumably
automatically deleting the existing table first?
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?
Regards
Tony Blackman
Tel (01404) 45982
Fax (01404) 46600
email tonyblac@n...
Message #2 by "Ken Schaefer" <ken.s@a...> on Sun, 18 Jun 2000 00:06:55 +1000
|
|
> 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
Message #3 by "Daniel Walker" <danielw@w...> on Sat, 17 Jun 2000 17:21:53
|
|
Or, alternatively, take a look at Robert Larsson's reply to jirleand's
post:
"ADO constsnts - 6/13/00"
Robert sent us the whole thing - the _whole_ of ADOVBS.INC
Nice one, Robert! ;-) (naw, go on, I'm only teasin'!)
On 06/17/00, "Ken Schaefer" wrote:
> > 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
|
|
|
View Cart
