How does one report a bug in Access 2007 SQL?

[Stewart Berman]

Access 2007

I am getting a "Specify the table containing the records you want to delete" error when trying to
delete rows in a linked table containing an attachment field using an inner join.

I have reproduced the problem using a table structure with two fields:
PrimaryKeyField Autonumber
Picture Attachment

The query is:
DELETE Table1.*
FROM Table1 INNER JOIN Table2 ON Table1.PrimaryKeyField = Table2.PrimaryKeyField;

With the attachment field in either table the query fails. If I remove the Attachment field from
both tables the query works.

This appears to be a bug in the Access 2007 SQL engine -- where do I report it?

 

[Douglas J. Steele]

Try:

DELETE FROM Table1 WHERE Table1.PrimaryKeyField IN (SELECT DISTINCT
PrimaryKeyField FROM Table2)


To be honest, I'm not sure what the current process is for the public to
submit feedback on bugs. You might go the Office Contact page and see
whether you find a useful link there
http://office.microsoft.com/en-ca/FX101538731033.aspx

 

[Stewart Berman]

I should have said I already know how to get around it but performance suffers.

I tried the link in your posting. There appear to be two options:
1. Enter a "feedback" note which is not acknowledged and which does not provide anyway to get a
response from Microsoft.
2. Pay Microsoft to report the bug.

I wish I could do that with my software -- get my users who have paid for the software to pay for
each bug they report.

 

[Van T. Dinh]

You need to use the DISTINCTROW predicate.

See Microsoft Knowledge Base
http://support.microsoft.com/kb/240098

 

[Stewart Berman]

Please see (e-mail address removed)

The query does not work using a join if there are any attachment fields no matter how many hints you
give MS Access.

The question here is how do you file a report of a bug in Access 2007 without paying Microsoft US
$95 for the privilege?