In the field which you have make sure it is set to NOT allow NULLS and check the IDENTITY field and set the seed to 1 and the increment to 1
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 10:35 AM Subject: Access to SQL Server > In Access you can set the primary key to auto number - how do you do this in > SQL Server? I would assume that has something to do with this error that I > am getting: > > Error Diagnostic Information > ODBC Error Code = 23000 (Integrity constraint violation) > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value > NULL into column 'UserID', table 'SaraLee.dbo.ChockUsers'; column does not > allow nulls. INSERT fails. > > > > Thanks! > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists