Re: Problem inserting or Modifying record

Article View: comp.databases.ms-access

Article #123

Back to comp.databases.ms-access Previous Next

#123

From: Darryl Johnson
Date: Thu, 28 Aug 1997 00:00

26 lines
1601 bytes

Alvaro Garriga wrote:
> 
> Hello:
> Thanks for taking your time to look at this message:
> I am getting a key violation when appending or modifying a record to a
> MS Access database using the BDE and a ODBC connection to a Access.
> 
> The table has a primary key. I am usign Visual Databse Tools and BC5.02
> 
> Thanks in advance
> --
> Alvaro Garriga, Programmer Analyst
> Email: agc@jhk.com

The data in one or more of the fields you are trying to add conflicts
with field properties (data type, indexing specifications, etc.)

It is hard to tell without details of all the fields in the database
and samples of the offending record changes...

HTH,
--
    Darryl Johnson                  Darryl.Johnson@nlc-bnc.ca
    National Library of Canada
      **  None of the above has any official status **

Technical Details

Message-ID: <34059165.9A4217B2@nlc-bnc.ca>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <34057B66.4D869B35@jhk.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f8d38,a54eaabcf7f7e389
X-Google-Attributes: gidf8d38,public
X-Google-Thread: ff0ac,a54eaabcf7f7e389
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10288e,a54eaabcf7f7e389
X-Google-Attributes: gid10288e,public
X-Google-Thread: ff75c,a54eaabcf7f7e389
X-Google-Attributes: gidff75c,public
From: Darryl Johnson <Darryl.Johnson@nlc-bnc.ca>
Subject: Re: Problem inserting or Modifying record
Date: 1997/08/28
Message-ID: <34059165.9A4217B2@nlc-bnc.ca>
X-Deja-AN: 268753231
References: <34057B66.4D869B35@jhk.com>
Organization: National Library of Canada
Newsgroups: comp.databases.ms-access,borland.public.cppbuilder.database,borland.public.delphi.database.desktop,borland.public.cpp.language

Reply to Parent Message