Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Validation Rule, Synchronization with Replica

Validation Rule, Synchronization with Replica

Validation Rule, Synchronization with Replica

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!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close