I recently converted my Access 2007 to SQL Server Express 2012. Just about everything is going fine ... except My Primary Key and Auto-increment.
In Access...I had a column usually called ID and this would auto increment as new records were added. From a coding perspective I never touched it However, now when I add new records I'm getting an error message that implies nothing is
being inserted into the ID column and of course nulls are not allowed. I went in (GUI) and changed the column to Primary Key and set Yes as Identity. But this still didn't help.
BTW...code is in VBnet
Any ideas???
...
Go to the complete details ...