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 - 2002-10-16 : 09:13:23
|
| Ramanujam writes "Hi!I have migrated from MS Access 2000 to SQL Server 7.0. The forms are designed in MS Access and they were working fine with Access Database. Problem is after upgrading to SQL Server, the Access forms from the .ADP file gives the error message 'Violation aaaaa[table_name]_PK Constraint' and cannot insert the record in the databse, but after i say ok to the message, and close the form i can see the record getting inserted in the table, i have made sure that i am not entering a duplicate record.I have service pack 4, and windows 2000 professional is my OS.I desperately need help.Thanx in advance,Ramanujam" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-10-18 : 17:17:58
|
| Script out your table from SQL Server and post it. |
 |
|
|
|
|
|
MS Access 2000 2 SQL Server 7.0