title: Access Validation Rule Violations on Append Query
body: <p>I'm recieving the following error on trying to run an append query in access.</p>
  
  <p>Microsoft Office Access set .... and it didnt't add... 779280 records(s) due to validation rule violations.</p>
  
  <p>If I choose to run the query anyways, nothing actually happens.</p>
  
  <p>To give some context, I'm simply trying to copy a populated field, consisting of values similar to "16-2009-02, 34-2010-02, et cetera" to another currently unpopulated field.</p>
  
  <p>The fields themselves have no set validation rules, and both have the standard text field options.</p>
  
  <p>I'm hoping to be able to simply remove those hyphens, and fix the issue.  But I guess that's what I'm not sure about, are those hyphens actually a problem?</p>
  
  <p>Running SP3 w/ Access 2003.</p>
  
  <p>Thanks in advance!</p>