469,140 Members | 1,137 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,140 developers. It's quick & easy.

SUPA URGENT UPDATE MYSQL from Access

Hi All

I am doing an update query from MS Access on a few records. The update work once perfectly but a soon as I run it again it returns the error below...

"I have 5 records that won't do what its told due to key violations
Database didn't update 0 field(s) die to a type conversion failure, 5 record(s) due to key violations, 0 record(s) due to lock violations and 0 record(s) die to validation rule violations. "

Is there anyway aound this ?

Big thanks
Aug 12 '07 #1
1 1592
JKing
1,206 Expert 1GB
Please include the MetaData for all relevant datasets. Here is an example of how to post table MetaData :
Table Name=tblStudent
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; AutoNumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Also please include the SQL for the UPDATE query you are performing.

MODERATOR.
Aug 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by David | last post: by
2 posts views Thread by Carlos Eduardo Peralta | last post: by
17 posts views Thread by kalamos | last post: by
7 posts views Thread by phillip.s.powell | last post: by
9 posts views Thread by zMisc | last post: by
1 post views Thread by dasilva109 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.