Results 1 to 2 of 2

Thread: Delete Query

  1. #1
    Join Date
    May 2003

    Unanswered: Delete Query

    I am trying to run a delete query.

    I have 2 tables.

    Table A and Table B.

    Table B holds all the records that I want to delete from Table A.

    In the query I create a link between the two tables. When I preview the query it displays all the records I want to delete.

    When I run the query in delete mode – it says “Could not delete from Specified table”

    Can anyone helpmeplease!

    Many thanks,

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place

    You can't delete because your criteria for the deletion is a join. The join effectively locks your records preventing deletion.

    You can, however, get round this with EXISTS
    or IN

    Personnally I tend to plump for Exists
    pootle flump
    ur codings are working excelent.

Posting Permissions

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