Delete Query

[Quang]

I've created a delete query in MS Access. The syntax seems to be correct. I'm comparing data from 2 tables and want to delete the records from one of those tables when value of a field in both tables match. I get an error saying that I can't delete from the specified table. Can anyone solve this problem?

Q

[Irene]

You could start by checking ownership of that table which won't allow you to delete, but that's just my first guess
It would be helpful if you could include the script for your query

Irene


------------
Quang at 4/25/00 5:10:05 PM


I've created a delete query in MS Access. The syntax seems to be correct. I'm comparing data from 2 tables and want to delete the records from one of those tables when value of a field in both tables match. I get an error saying that I can't delete from the specified table. Can anyone solve this problem?

Q