472,133 Members | 1,196 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,133 software developers and data experts.


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 1712
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.

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.