Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

can't update listitem in access in a sharepoint list

Posted on 2015-02-03
8
777 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

860 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