• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1295
  • Last Modified:

can't update listitem in access in a sharepoint list

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 SP2013 and Access 2010/13.

You can still modify them in SharePoint with no issues. Any help will be really appreciate it.
0
ebertsys
Asked:
ebertsys
  • 5
  • 3
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
What datatype is the field defined as?
For example, ...perhaps users are entering Currency values and adding in the "$" sign...
Or there is a part number filed for numbers only, and users are entering values like: 561B, or 870-6.

Not sure without a specific example...

JeffCoachman
0
 
ebertsysAuthor Commented:
it dosen't matter what field..i try too update first a currency field..don't work..got error.
after that i try to update a simple textfield..same error.
when i have the list in access open..i can update each field by hand...typing values.
when i want to do that in sql or in access-vb ...got error
0
 
ebertsysAuthor Commented:
first i try that in access 2013..because weeks ago i change office from 2010 to 2013
but same error.
I'm the owner of the list in sharepoint
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Jeffrey CoachmanMIS LiasonCommented:
Sorry, I misread your error.
a data integrity rule
The most typical is hat you are trying  enter a "Child" record for a Parent record hat does not exist.

For example, you have Customers and Orders.
If you try to enter an Order for a Customer who does not exist, you may get an error like this.

So make sure your system is set up to only allow users to enter valid (already existing) values in the Child fields
For example, When entering an order, you can only assign orders for existing customers.

JeffCoachman
0
 
ebertsysAuthor Commented:
i update an order that  allready exist
has so far no childsrecords!
i copy the list to other SP2013 and try to do the same..other error...the list is write protected
0
 
ebertsysAuthor Commented:
its only on some records..not on all
0
 
Jeffrey CoachmanMIS LiasonCommented:
Lets wait for a sharepoint expert to chime in...
I am sure there must be a way to update the list....
0
 
ebertsysAuthor Commented:
:) i did exclute the one record and continue with my work.
Now all its fine.
Thanks for help
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now