I am currently moving an existing Access Database into a Sharepoint 2007 site for tracking user enhancement requests. The Sharepoint site is very simple with two main Lists, one of which contains the initial request information that could be updated by admins via the Access Database. What I am finding when editing some of the records in the linked Sharepoint Table in Access is that I receive the following error and cannot for the life of me figure out why it is only occurring on some records and not all? Here is the Error:
You cannot update this field because the value you're trying to apply is not valid or would break a data integrity rule. Please correct and try again.
The interesting thing is that I have changed other records to the same value I was attempting on the record that would not work and it was accepted with no problems.
Does anyone know why this may be occurring and how I can possibly prevent it from happening?