How to remove the Duplicate Index error message?

From: Asaf (asafgo_at_hotmail.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 15:12:51 +0200

Hi,

I have created an Access DB Table with a String field with index and not
duplicate.

In Delphi when I try to insert a new record that exists in the table I am
getting this pop up message box:

"The changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate entries and try again."

How can I eliminate this message from pop up?

I could not find any event for doing that in ADOConnection & ADOTable.

Thanks in advanced for any help.

Asaf

Relevant Pages

  • Re: How to remove the Duplicate Index error message?
    ... >In Delphi when I try to insert a new record that exists in the table I am ... >would create duplicate values in the index, primary key, or relationship. ... >Change the data in the field or fields that contain duplicate data, ... to cancel the error message. ...
    (borland.public.delphi.database.ado)
  • Re: How to remove the Duplicate Index error message?
    ... >>In Delphi when I try to insert a new record that exists in the table I am ... >>would create duplicate values in the index, primary key, or relationship. ... >>Change the data in the field or fields that contain duplicate data, ... > to cancel the error message. ...
    (borland.public.delphi.database.ado)
  • Re: How do I remove Duplicate rows?
    ... of duplicate data which messes up the data in relation to the row. ... Dim Numrows As Integer ... How would I modify this code if the duplicate data is by the entire ...
    (microsoft.public.excel.misc)
  • Weird Access posting problem - any clues?
    ... the table were not successful because they would create duplicate ... the field or fields that contain duplicate data, remove the index, or ... // Build/Initialize Session Record ... The FillSessions subroutine looks something like this: ...
    (comp.lang.pascal.delphi.databases)
  • How to remove code?
    ... I have been having alot of grief with my database these couple of days. ... create duplicate values in the index, primary key, or relationship. ... the data in the field or fields that contain duplicate data, ... I managed to delete the report that seemed to be the problem but now it ...
    (microsoft.public.access.forms)