You might want to check out other tips upsizing Access to SQL server in the article http://www.cfug-md.org/articles/upsizefrommsaccesstosqlserver.cfm
- Michael Smith, TeraTech, Inc http://www.teratech.com/ Clint Tredway wrote: > You need to set this field to an 'int' datatype and then set it as an ident > ity field. That will help. > > HTH > Clint > > ---------- Original Message ---------------------------------- > from: <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > date: Fri, 8 Feb 2002 08:35:55 -0700 > > In Access you can set the primary key to auto number - how do you do this i > n > 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 valu > e > NULL into column 'UserID', table 'SaraLee.dbo.ChockUsers'; column does not > allow nulls. INSERT fails. > > Thanks! > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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