Results 1 to 1 of 1
  1. #1
    Sana Firdaus is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    22

    Sharepoint list brought down in Access db file showing error while loading data through Access db?


    I have a choice field in share point list and there are more than 100 choices in it.while in the dropdown for that field in sharepoint site ,it is showing all the values,but when i track this list in Access db and go over to the field,in dropdown no values are shown in access db file.So,while loading any data through access db,it shows error"the value you are trying to update is breaking the data integrity rule".I know the cause of error because in access db,for that field it is not recognising any choice value and therefore giving the error.I have attached the extract having the field with the choices.Kindly help?
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Error Loading DLL in Access 2010
    By Terry Lawson in forum Import/Export Data
    Replies: 2
    Last Post: 02-03-2017, 02:16 PM
  2. Replies: 1
    Last Post: 08-10-2016, 04:55 PM
  3. Replies: 1
    Last Post: 02-01-2016, 07:21 PM
  4. Importing file directly from a Sharepoint file (not list)
    By jstoler in forum Import/Export Data
    Replies: 1
    Last Post: 06-28-2013, 01:44 PM
  5. Replies: 3
    Last Post: 05-30-2012, 01:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums