..."change field type in ASP" and you should find what you need: http://www.google.co.uk/search?sourceid=navclient&ie=UTF-8&q=change+field+type+in+ASP<BR><BR>If not, try http://www.w3schools.com.<BR><BR>Oliver.
Thanks.<BR><BR>Sir, I couldnt find any article relating to identity insert on w3schools.org. please advise. i have got many search results on google, but couldnt find any for (identity change).<BR><BR>plz advise.<BR>--solo
..and I'm not 100% sure which database you're using (I assume SQL Server???), but you probably need to execute an "ALTER TABLE" SQL statement (connection.execute()). I just can't tell you what the parameters are, but I'm sure if you search the Microsoft website's SQL Server documentation (if that's the database you're using) you should find what you need.<BR><BR>Oliver.