Delete Query

[Ted]

I'm trying to delete out items in my "Garment table" based
on information from another database table
called "MatrixFil". Both tables have a multiple primary
key. MatrixFil key is "Style", "Color", and "Size".
Garment key is "Style" and "Color". When I set up the
Query I join only the "Style" and "Color" and join showing
all items from the garment table and those that equal from
the MatrixFil. I then show all of the "Is Null" items
from the MatrixFil. This Does give me the correct
information but...When I run the query it says "Could not
delete from specified tables". Any Ideas?

 

[Gary Walter]

Hi Ted,

http://support.microsoft.com/default.aspx?scid=kb;en-us;207761

***quote**

Delete Queries
****************************************************************************
******
When a delete query contains more than one table,
such as a query that deletes duplicate records from one of the tables,
the UniqueRecords property must be set to Yes for all versions of Microsoft
Access.
****************************************************************************
************
However, because the default value for UniqueRecords is No in Access 2000,
you must set the value of this property manually when you create a new
delete query in Access 2000.

To do so, follow these steps:
Open the delete query in Design view.
If the property sheet is not already open, on the View menu, click
Properties.
Click an empty area in the upper half of the query window so that the
property sheet displays "Query Properties" in the title bar.
Set the UniqueRecords property to Yes.
Save the query, close it, and then run the query.
***unquote**