violation of primary key constraint .Cannot insert duplicate key in object using ADO

Posted by CREFLY on Stack Overflow See other posts from Stack Overflow or by CREFLY
Published on 2010-04-09T06:17:06Z Indexed on 2010/04/09 6:23 UTC
Read the original article Hit count: 522

Filed under:

error

|

key

|

Constraint

|

vba

|

access-vba

Hi All we are working on a users apllication using Access2003(VBA) as software language and SQL Server 2005 as database. We are using ADO method and we encounter a problem. when users create new record in a ADO Screen and they want to save the record after implementing it they receive this error : error -2147217873 violation of primary key constraint 'PK_ '.Cannot insert duplicate key in object 'Pk_...' Any help will be appreciated Thanks in advance

© Stack Overflow or respective owner

Related posts about error

Prevent malicious vulnerability scan increasing load on a server

as seen on Server Fault - Search for 'Server Fault'
Hi all, this week we have been suffering some malicious vulnerability scans to our servers, increasing the load on them, making them nearly unusable. The attack is easy to defend, just blocking the offending ip, but only after discovering it. Is there any form of prevent it? Is it normal that… >>> More
Installation of SAP Web Application Server 6.20 fails

as seen on Super User - Search for 'Super User'
I tried installing a trial version of SAP NetWeaver 7.1 on Windows Vista on my laptop but I couldn't succeed. Then I tried installing SAP Web Application Server 6.20. The installation goes all the way to 91%, at which point I get some errors and the installation stops. Does anyone have any experience… >>> More
MAMP + Python MySQLDB - trouble installing

as seen on Server Fault - Search for 'Server Fault'
I'm currently running the latest version of MAMP on my Snow Leopard OSX, and I'm trying to install MySQLDB. Downloaded: MySQL-python-1.2.3c1 I went into the setup_posix.py and adjusted the location of the mysql_config to the one in MAMP: mysql_config.path = "/Applications/MAMP/Library/bin/mysql_config" When… >>> More
Installation of SAP Web Application Server 6.20 in Windows Vista

as seen on Super User - Search for 'Super User'
I tried installing trial version of sap netweaver 7.1 in windows vista in my laptop but i couldnt succeed there.. then i tried installing SAP WEB AS 6.20 now.I am able to succeed till 91% completion.After that i get some errors and the installation stops... if anybody have any experiences please… >>> More
Installation of SAP Web Application Server 6.20 in Windows Vista

as seen on Stack Overflow - Search for 'Stack Overflow'
I tried installing trial version of sap netweaver 7.1 in windows vista in my laptop but i couldnt succeed there.. then i tried installing SAP WEB AS 6.20 now.I am able to succeed till 91% completion.After that i get some errors and the installation stops... if anybody have any experiences please… >>> More

Related posts about key

tmux: Suddenly, cannot horizontally split

as seen on Server Fault - Search for 'Server Fault'
As root, using a reasonably default .profile and .shrc and an empty tmux.conf, I am unable to split the window horizontally. There are a number of cases to consider so I'll list them clearly. Using the keybinding + empty configuration: nothing happens Using the keybinding + my configuration: a bell… >>> More
Foreign key reference to a two-column primary key

as seen on Stack Overflow - Search for 'Stack Overflow'
One of my tables has a two-column primary key: CREATE TABLE tournament ( state CHAR(2) NOT NULL, year INT NOT NULL, etc..., PRIMARY KEY(state, year) ); I want a reference to the tournament table from another table, but I want this reference to be nullable. Here's how I might do… >>> More
Numeric Data Entry in WPF

as seen on Stack Overflow - Search for 'Stack Overflow'
How are you handling the entry of numeric values in WPF applications? Without a NumericUpDown control, I've been using a TextBox and handling its PreviewKeyDown event with the code below, but it's pretty ugly. Has anyone found a more graceful way to get numeric data from the user without relying… >>> More
Elfsign Object Signing on Solaris

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Elfsign Object Signing on Solaris Don't let this happen to you—use elfsign! Solaris elfsign(1) is a command that signs and verifies ELF format executables. That includes not just executable programs (such as ls or cp), but other ELF format files including libraries (such… >>> More
Force Quit - Short cut key on regular key - mac osx

as seen on Super User - Search for 'Super User'
Very confusing question here. I want to use the short cut key of force quit - in mac os x. It is written as follows. Command + Alt / Option + Reverse Q ( like key ). I am unable to use this short cut key. Any help please. Sagar >>> More