January 31, 2013 at 3:51 pm
i try to convert from access database to MSSQL Server but there's an error the error msg is "Attached table is not updatable because it has no unique index." can any one explain what is this error. do you have any sugestion or another way to convert it in sql.. thanks in advance
February 1, 2013 at 8:57 am
john_edman24 (1/31/2013)
i try to convert from access database to MSSQL Server but there's an error the error msg is "Attached table is not updatable because it has no unique index." can any one explain what is this error. do you have any sugestion or another way to convert it in sql.. thanks in advance
What you mean you tried to convert from access to SQL? You are migrating the data or are you running an update in Access to update a SQL table? From your message I am guessing you have a linked table in Access but the table has no primary key in SQL. The fix is quite simple. Add a primary key or a unique index in sql.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply