adox asp ms access delete a column from a table

[Scotter]

Hi folx -

Here is the code I'm trying (but it errors out with "Item cannot be found in
the collection corresponding to the requested name or ordinal."):

objTable.columns(s_name_field_to_delete).delete
AND SAME ERROR WITH:
objTable.columns.delete s_name_field_to_delete

What am I doing wrong?

Thanks!

--
Scotter

[Ray at]

Show more code than that. Or make sure you variable has the value you think
it does. And also instead of ADOX, you could just use the existing ADO
connection and execute:

oADO.Execute "alter table TableName drop [" & s_name_field_to_delete & "]"

Ray at home

"Scotter" <spam@spam.com> wrote in message
news:7a7Hc.2169$857.1509@fe2.texas.rr.com...

> Hi folx -
>
> Here is the code I'm trying (but it errors out with "Item cannot be found

in

> the collection corresponding to the requested name or ordinal."):
>
> objTable.columns(s_name_field_to_delete).delete
> AND SAME ERROR WITH:
> objTable.columns.delete s_name_field_to_delete
>
> What am I doing wrong?
>
> Thanks!
>
> --
> Scotter
>
>

[[MSFT]]

Hio Scotter,

Please refer to Bob's reply in microsoft.public.inetserver.asp.general

Thanks,

Luke