We have a SharePoint list linked to Access which has been working fine for the last few months. We have a couple of users who use the Access DB to modify records in the SharePoint list. Suddenly we are now getting the following error when trying to modify any record or in Access: "You cannot update this field because the value you're trying to apply is not valid or would break a data integrity rule". We are using WSS 3.0 and Access 2007. You can still modify them in SharePoint with no issues. Any help will be really appreciate it.

This error occurs when Referential Integrity is setup on a table against another table. This is typically used to prevent a user from adding data to a child list that does NOT exist in the parent list. For example, Products and Categories. You want to assign a product to a category, but only if the category exists in the list. The opposite can occur as well, where if you try to delete a category, then the application needs to know what to do with all the would be orphans. So, I can definatively say what your problem is, but this is the basis. Thus, do a little research in the setup of the relationships and see what you can learn.Steve Clark, MCTS | Twin-Soft.com

JesusPM, It looks you have made changes in the list after initial connection to Access; if this is true than you will have to reconnect to the SharePoint list from within Access, hitting the refresh button will not be enough. If you're trying to run an Append Query to a SharePoint list from within Access, you have to re-connect to the list after making changes to any choice fields in your SharePoint list. Otherwise, your query may not work because it could violate data integrity rules. Other possible reason for this issue could be datatype mismatch and thus a data type problem. Check and see what Access has assigned as a data type for each field imported from Excel text, date, number, etc. Refer following article for more detail on suggested solution: http://unitedsupplyco.sharepointsite.net/publicfacing/bensblog/Lists/Posts/Post.aspx?ID=40Leonid Lyublinski Wizard of MOSS

This just happened to me. It turns out that one of the other fields in the linked table had a value that was not included in the 'Choice' options on the Sharepoint page. For example, the Choice options were 'AM, EMEA, APAC' and the field value was 'AMERICAS.' Changing this to one of the available options made the record updatable as expected.

I also had this type of issue. I could not find any data that I was loading that broke the integrety rules. What I found in the end was that existing data was breaking the rules and updating another field in the same record caused this error. Apparently SharePoint allows you to change the integrety rules even if your existing data breaks the rules. Most of the examples were SharePoint 'Choice' fields. However, I also had some 'People & groups' fields that link to the SharePoint user table. My IT department deletes users from SharePoint when they leave the company and this leaves records referring to a person that no longer exists in SharePoint. I hope this helps others with this problem RoryRegards Rory