Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-04 : 08:50:47
|
| Joe Randle writes "I have been recently asked to convert my MS Access database from an Access backend and Access frontend to an SQL backend with an MS Access frontend. While I am reasonably conversant with MS Access, I am not that acquainted with SQL. The intention is to only store the data tables in SQL and all other functions will be done by an Access *.mdb front end.All went fine, however, my primary keys in the MS Access environment used the AutoNumber type to generate a unique value. When it was upsized to SQL, that type was changed to just a Number. My input forms will no longer save new entries because the primary key field is not generating a unique value so I am getting an ODBC error message saying that the field cannot contain NULL values, which makes sense cause I don't want it to.To make a long story short. How do I make a primary key auto increment in SQL tables so I can enter new data??" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-11-04 : 08:54:02
|
| look at the identity property on numeric columns |
 |
|
|
|
|
|
AutoNumber from MS Access to SQL