I have a design master with a validation rule set for a Permits field that limits the data to be entered so it must start with specific characters. It also has a validation text property that explains the rule.
I created a replica of the design master. I changed an entirely DIFFERENT field (Applicant) in the same record in both files for testing purposes and then synchronized.
When opening the conflict viewer, I attempted to change the data to what existed in the replica (override what was in the design master). I got an error message that referred to the validation text in the Permits field. Here's the exact message:
The conflict viewer was unable to perform the specified action. The error -2147467259 was raised by Microsoft Jet Database Engine with the message of 'Invalid: Must start with AT, CH, MD, MT, NU, OT - Try Again!'. To continue, you must choose a different action or postpone resolution of this conflict for the time being.
'Invalid: Must start with AT, CH, MD, MT, NU, OT - Try Again!' is the Validation Text in a Permit field. The field that was changed was an Applicant field that has NO validation at all.
Why would this occur if the conflict exists in a field (Applicant) that has no validation rule at all and wasn't even modified in either database?
The error does not occur if I choose to update both tables with the data that was entered in the design master or if I choose to type my own value in the conflict viewer.
Any help would be appreciated! Thank you!!