How does one report a bug in Access 2007 SQL?

  • Thread starter Thread starter Stewart Berman
  • Start date Start date
S

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?
 
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.
 
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?
 
Back
Top