Results 1 to 2 of 2
  1. #1
    tonyhansson is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2020
    Location
    Copenhagen, Denmark
    Posts
    21

    Sharepoint list failure (Read Only)

    Hi


    I have 2 list I update from Access to sharepoint.

    First list I run 3 query (Add, Update, Delete) no problems.

    Second Liste the same 3 query (Add, Update, Delete).

    When i come to the last Query Delete most of the times I get the failure (Cannot update, database or object is read only)

    If i keep running the query sometimes it will work. ( Ivahe set the cache to "Never")


    Did anyone have this issue?


    Regards



    Tony

  2. #2
    tonyhansson is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2020
    Location
    Copenhagen, Denmark
    Posts
    21
    According to experts my query has to been run in batches

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

Similar Threads

  1. Populate List Box & Read Value From VBA
    By Juan4412 in forum Programming
    Replies: 3
    Last Post: 05-29-2017, 01:19 PM
  2. Replies: 9
    Last Post: 04-20-2015, 10:12 AM
  3. Read excel file from sharepoint site
    By selvakumar.arc in forum Import/Export Data
    Replies: 1
    Last Post: 10-12-2013, 06:34 AM
  4. Refresh SharePoint List - SharePoint 2010
    By jgelpi16 in forum Programming
    Replies: 0
    Last Post: 08-22-2013, 06:21 AM
  5. Importing SharePoint list
    By darrbeck in forum Access
    Replies: 1
    Last Post: 09-09-2012, 11:08 AM

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