Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    5

    Unanswered: Error 3086 - simple Access Delete Wont Run

    Having problems getting simple access delete query to work. Select works fine but get Error 3086 when I try to delete. I want to delete all records in 1 table if they have matching Date records in table 2. This is my Sql:

    DELETE [Daily DB].*
    FROM Max_Date LEFT JOIN [Daily DB] ON Max_Date.X_DATE = [Daily DB].X_DATE;

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    I don't know what error 3086 is; what's the message text?

    In any case, why the left join? You need an inner join if you want to delete what's equal, not a left join. Be happy the delete didn't work. With the left join, and no WHERE clause to define a filter, you would have deleted the entire contents of the table.

    Sam
    Last edited by Sam Landy; 08-22-12 at 11:44.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •