0

I transferred a MS Access database to SQL Server. It appears that all data was transferred.

The primary key values were placed it the appropriate columns and can be found by there value. However I can not add a new row to that table. My research says that the problem is that there is no identity property added to this column. As these primary keys and identity field need to be the same number. Identity_insert ?

Improve this question
2
  • What error are you getting when you try to add a new row? I'm guessing the column that used to be your identity in Access is not an identity column in SQL Server. You'll need to recreate the "identity" column because you can't enable identity on an existing column. stackoverflow.com/questions/288222/… Commented Jan 24, 2014 at 22:21
  • If you have the primary keys like in Access then why do you need identity? Do you want identity or not? Commented Jan 24, 2014 at 22:23
Related questions
1
Identity and primary key
0
How to transfer my data from MS ACCESS DB to a new SQL SERVER DB?
0
How can I get round identity issues with Importing Access data into SQL Server
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.