Hi guys,<BR><BR>I have just switched from an access database to an SQL Server.<BR>Everything works fine except for the "access autonumber" field.<BR>Everytime i try to add a new record and let the database increment my "autonumber" field it gives me an error on the SQL Server saying that I cant insert a "NULL" value into the ID field.<BR><BR>I know that I have to convert the old "autonumber" fields from access to an "IDENTITY" field in SQL Server but I am not quite sure how to acomplish this with asp and SQL.<BR><BR>I am guessing it would be something like...<BR><BR>SQL = "Alter Table MyTable Modify (MyId INT IDENTITY)"<BR><BR>or something in that direction... <BR>any help would greatly be appreciated.<BR><BR>Thanks,<BR>andre