Solved

can't update listitem in access in a sharepoint list

Posted on 2015-02-03
8
653 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
 
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now