Solved

can't update listitem in access in a sharepoint list

Posted on 2015-02-03
8
591 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

24 Experts available now in Live!

Get 1:1 Help Now