Results 1 to 6 of 6
  1. #1
    tonyhansson is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Aug 2020
    Location
    Copenhagen, Denmark
    Posts
    34

    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
    9,521
    what did your delete query look like?

  3. #3
    tonyhansson is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Aug 2020
    Location
    Copenhagen, Denmark
    Posts
    34
    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 Advanced Beginner
    Windows 10 Office 365
    Join Date
    Aug 2020
    Location
    Copenhagen, Denmark
    Posts
    34
    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 Advanced Beginner
    Windows 10 Office 365
    Join Date
    Aug 2020
    Location
    Copenhagen, Denmark
    Posts
    34
    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)

  6. #6
    tonyhansson is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Aug 2020
    Location
    Copenhagen, Denmark
    Posts
    34
    Changed not using inner join

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