 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2008Validation Rule?
When I run in append query (which has worked in the past), Access now tells me all but 7 records violate some unforseen validation rule. All the records contain the same fields of the same length and there are no validation rules on any of the fields in the target table. Help! Do you have a UNIQUE index on a field? Do you have a relationship where a field is dependent on a field in another table and you are putting in values that don't exist in the other table? John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County > When I run in append query (which has worked in the past), Access now tells > me all but 7 records violate some unforseen validation rule. All the records > contain the same fields of the same length and there are no validation rules > on any of the fields in the target table. Help! I do have a unique index on one field, but there are no duplicate values in table being inserted. I was able to reverse the append operation - appending records from the target table to the source - but I cannot go back the other way. I also checked field lengths and types and everything seems to be in order. > Do you have a UNIQUE index on a field? > [quoted text clipped - 10 lines] > > contain the same fields of the same length and there are no validation rules > > on any of the fields in the target table. Help! After trial and error it appears allowing the fields to accept zero length strings was the issue. > I do have a unique index on one field, but there are no duplicate values in > table being inserted. I was able to reverse the append operation - appending [quoted text clipped - 16 lines] > > > contain the same fields of the same length and there are no validation rules > > > on any of the fields in the target table. Help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.