Delete Query problem

[JHSam]

Another question with my ongoing adventures in dealing with Access queries ...

I am trying to run a delete query, which removes records in a given field in Table 1 that match those in Table 2. I can set this up OK and when I do a view the dynatable looks like its picking the correct records out to delete, but when I actually run the delete query I get a message "Could not delete from specified tables". I've tried linking and not linking the tables, and including a value in the 'Where' box or leaving it empty.

The SQL is something along the line of the following (I may have messed up the parentheses and brackets since this is an edited copy):
DELETE [Table1].*, Table2.TargetField
FROM [Table1]
WHERE (((Table2.TargetField)=Table1.Target Field));

Any suggestions would be appreciated.

Thanks.

 

[Russell Hauf]

Uncheck the Show box for the field in Table 2. As far as I know, you can only delete records in one table at a time. So the SQL would look something like this:

DELETE [Table1].*
FROM [Table1]
WHERE (((Table2.TargetField)=Table1.Target Field));

Hope this helps,

Russell

 

[JHSam]

Unfortunately that didn't work since there aren't any checkboxes in the delete query. The dynatable showed the linked field, which may be why the query is not running properly.

Why do these things always happen when there are deadlines ...?

 

[Russell Hauf]

Sorry, just paste in the SQL (changing table and field names as necessary). If you change the query to a SELECT query, you can uncheck the box, then change it back to a DELETE query (should work, anyway - not tested).

HTH,

Russell

 

[JHSam]

It still acted up ... I opted for a "Finding Unmatched" make-table Query instead -- sort of a "create by force" approach.

Thanks for the help.