Modifying an Access DB schema using ASP code

Hi All

If possible, could you please confirm what the ASP query syntax would be to
add an extra field into an Access table at a particular position, eg after
field4 and before field5.

Thanks

Robbie

Re: Modifying an Access DB schema using ASP code

Astra wrote on 30 dec 2004 in microsoft.public.inetserver.asp.db:

> If possible, could you please confirm what the ASP query syntax would
> be to add an extra field into an Access table at a particular
> position, eg after field4 and before field5.
>

Impossible, I think.

You don't need that if you call the fields by name.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Re: Modifying an Access DB schema using ASP code

You would have to drop the table and re-create it. Why do you care what
order the columns are in?

--
http://www.aspfaq.com/
(Reverse address to reply.)




"Astra" wrote in message
news:eopq#gl7EHA.2156@TK2MSFTNGP10.phx.gbl...
> Hi All
>
> If possible, could you please confirm what the ASP query syntax would be
to
> add an extra field into an Access table at a particular position, eg after
> field4 and before field5.
>
> Thanks
>
> Robbie
>
>