Results 1 to 5 of 5
  1. #1
    tonyhansson is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2020
    Posts
    8

    Update and delete sharepoint with Access

    Hi

    I'am trying to update my sharepoint list, using Access.


    Update is working fine with an update query.


    I can't make a delete query work, delete unused rows. Ib have made a normal query finding
    unused rows, but can't delete the rows.



    Has any one a solution for this ?

    Regards

    Tony

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,461
    what did your delete query look like?

  3. #3
    tonyhansson is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2020
    Posts
    8
    Hi I have this:

    Delete Delete.SourceUp.Title, Delete.[Employee ID], Delete.SourceUp.[User Name], Delete.SourceUp.Department, Delete.SourceUp.Status, Delete.Tabelle1.Title, Delete.[Emplyoyee ID], Delete.Tabelle1.[User Name], Delete.Tabelle1.Department, Delete.Tabelle1.Status
    FROM [Delete];


    I have one tabel (Tabelle1) join with Sharepoint tabel (SourceUp), it works correct as a normal query, it finds the different rows between the two tabels, but i cannot delete the rows.

    I have a query that delete all rows in Sharepoint, this one works fine.

  4. #4
    tonyhansson is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2020
    Posts
    8
    Sorry

    Here is the right one:

    DELETE SourceUp.Title, SourceUp.[Employee ID], SourceUp.[User Name], SourceUp.Department, SourceUp.Status, Tabelle1.Title, Tabelle1.[Emplyoyee ID], Tabelle1.[User Name], Tabelle1.Department, Tabelle1.Status
    FROM SourceUp LEFT JOIN Tabelle1 ON SourceUp.Title = Tabelle1.Title
    WHERE (((Tabelle1.Title) Is Null));

  5. #5
    tonyhansson is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2020
    Posts
    8
    Hi

    The problem seems to be, that the TITLE (first column) cannot be deleted, it works if I only coose all orther fields.
    (Fields are empty but th row is still there, with value in title)

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

Similar Threads

  1. Replies: 3
    Last Post: 06-10-2015, 10:06 AM
  2. Replies: 2
    Last Post: 01-05-2012, 11:52 AM
  3. MS Access - Update/Delete Error
    By Scyclone in forum Programming
    Replies: 20
    Last Post: 09-19-2011, 11:37 AM
  4. Update/Delete Outlook appointments from Access
    By IdleJack in forum Programming
    Replies: 1
    Last Post: 09-12-2011, 03:48 PM
  5. Update / delete and recreate access tables
    By metro17 in forum Access
    Replies: 4
    Last Post: 09-23-2009, 04:45 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 - Senior Forums