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 |
|
muhiar
Starting Member
37 Posts |
 Posted - 2006-03-19 : 08:03:23
|
| hi alli have a bigggggggggggggggggggggg problemi have an msaccess application with tables in msaccess toi migrate the tables to be sql server 2000 onesfor each table i added in auto serial to be auto number and primary keythe problem is that all the delete and append queries no longer workit keeps displaying a message can't append all records in the querydue to key violationdoes any body know how to solve it????????or other ideas??? |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-19 : 08:30:02
|
| Are you getting these error in SQL Server or Access?? you can not update the Identity column in the Identity columns. Give some more information so that we can help you in much faster way ..Sucess Comes to those who Believe in Beauty of their Dream.. |
 |
|
|
muhiar
Starting Member
37 Posts |
Posted - 2006-03-20 : 00:57:57
|
| thnx 4 ur responsethese queries run in msaccess application with linked tables and primary key of those tablesaffected are identity that has to be auto increment???? |
|
|
|
|
|
|
queries problems,urgent