Deletion Error in Access (Access97)

Topic

New Reply

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

Reply | Quote

Replies

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

viola

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

J

Reply | Quote

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

Reply | Quote