When I am trying to run the following query in Access 2000, I get the "Could not delete from specified tables." error message.



DELETE tblDetailHistory.* FROM tblDetailHistory INNER JOIN tblParameters ON tblDetailHistory.BillingDate = tblParameters.AcctDate;

tblParameters is a one row table where the user is able to type the desired Acct =Data.

If I change the query to remove the link to tblParameters and manually key the criteria, it works fine.

tblDetailHistory has no indexes or keys that seem to be the issue.

Any ideas?

Thanks