Improve company productivity with a Business Account.Sign Up

x
?
Solved

can't update listitem in access in a sharepoint list

Posted on 2015-02-03
8
Medium Priority
?
1,412 Views
Last Modified: 2015-02-03
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
Comment
Question by:ebertsys
  • 5
  • 3
8 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40587404
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
 

Author Comment

by:ebertsys
ID: 40587424
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
 

Author Comment

by:ebertsys
ID: 40587430
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40587447
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
 

Author Comment

by:ebertsys
ID: 40587482
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
 

Author Comment

by:ebertsys
ID: 40587509
its only on some records..not on all
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 40587645
Lets wait for a sharepoint expert to chime in...
I am sure there must be a way to update the list....
0
 

Author Closing Comment

by:ebertsys
ID: 40587658
:) i did exclute the one record and continue with my work.
Now all its fine.
Thanks for help
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question