Changing ordinal position and datatype

Does anyone know how to change the ordinal number of a field and the field datatype in Access using ASP?

Thanks

Alter keyword is used to change the properties of your database

Try this (http://www.w3schools.com/sql/sql_alter.asp) link... its from w3schools.com. You should search that site sometimes before you post.... it has alot of stuff and info there!


I also did a little search for you and here are some tutorials... I had a similar concern recently... hope these links help! :) :thumbsup:

This link (http://www.ilook.fsnet.co.uk/ora_sql/sqlhlp22.htm) directly discusses the ALTER keyword.

This, I think is another useful tutorial... http://sqlzoo.net/howto/source/s.pl.htm?index=i02create.xml&e=sqlserver

And the last link, a tutorial from plus2net (http://www.plus2net.com/sql_tutorial/sql_introduction.php).

Hope these helped you out!!! :thumbsup:

Great tutorials! Thank you.

u r welcome man!!!! :thumbsup: