Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Deletion Error in Access (Access97)

    Hi all,

    Need some quick help with what should be a simple situation. It's been driving me nuts for like 2 hours now.

    I have a table, Table A, with 60 social security numbers in it. I want to delete the matching records from Table B with 38,000+ records in it. But when I construct my delete query and try to run it (only has the 2 tables in it), it says "Operation must use an updatable query." Checked help. It doesn't. What's going on ? How do I construct this query ?

    Actually would like to know how to do the reverse of a join. Joining Table A to Table B, I want only the records in B do not satisfy the join from A.

    Thanks,

    Donna

  2. #2
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Deletion Error in Access (Access97)

    In answer to your second question:

    Add the two tables to a query

    Create the Join
    Right click the join
    Select the join that shows all records from B and only matching records from A

    then..

    Add to the query the joined field in table A, and give it the criteria of IS NULL (you will also want to add any field you want to see from table [img]/forums/images/smilies/cool.gif[/img]

    viola

    You should get a result set returned that gives you all records in B, that do not exist in A

    J

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Deletion Error in Access (Access97)

    Try changing the Unique Records in the query properties from No to Yes.

Posting Permissions

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