SQL Server 2005 - Insert Problem

Hi All

I have a table in my database called YM_WEB_APPLICATIONS in this table I have a field called ApplicationID everytime an insert happens this increments by one.  Inserts work fine if I don't set this ApplicationID as a primary key, but I set it as a primary key inserts will not happen, there is no error so I'm a bit stumped. Any ideas?

Here is an extract of my SQL statement: -

strsqlinsert = "INSERT INTO YM_WEB_APPLICATIONS ( "
strsqlinsert += "Surname, Forenames, Title, DOB, EmailAddress, Gender, EmergencyContactName, EmergencyContactNumber, "
strsqlinsert += "Convictions, ConvictionsList, NationalIdentity, NationalIdentityOther, Ethnicity, EthnicityOther, FirstLanguage, FirstLanguageOther, PreferredLanguage, SpeakWelsh,"
strsqlinsert += "HouseNoStreet, Locality, Town, County, Postcode, HomeTelephoneNumber, MobileTelephoneNumber,"
strsqlinsert += "Qualifications, SchoolCollege1, From1, To1, SchoolCollege2, From2, To2, Employment,"
strsqlinsert += "Disabilities, MedicalCondition, SpecialArrangements,"
strsqlinsert += "Marketing, MarketingOther,"
strsqlinsert += "InterviewSlot"
strsqlinsert += ")"
strsqlinsert += " VALUES ("
strsqlinsert += "@Surname,@Forenames,@Title,@DOB,@EmailAddress,@Gender,@EmergencyContactName,@EmergencyContactNumber,"
strsqlinsert += "@Convictions,@ConvictionList,@NationalIdentity,@NationalIdentityOther,@Ethnicity,@EthnicityOther,@FirstLanguage,@FirstLanguageOther,@PreferredLanguage,@SpeakWelsh,"
strsqlinsert += "@HouseNoStreet,@Locality,@Town,@County,@Postcode,@HomeTelephoneNumber,@MobileTelephoneNumber,"
strsqlinsert += "@Qualifications,@SchoolCollege1,@From1,@To1,@SchoolCollege2,@From2,@To2,@Employment,"
strsqlinsert += "@Disabilities,@MedicalCondition,@SpecialArrangements,"
strsqlinsert += "@Marketing,@MarketingOther,"
strsqlinsert += "@InterviewSlot"
strsqlinsert += ")"
strsqlinsert += "; SELECT SCOPE_IDENTITY() ; "