kingtutt said:
if any one knows why i get a message "couldnt delete from table specified" when i
try to run a delete queiry
If your query involves more than one table
and you are using Access 200x,
the following may help:
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****
Beyond the above gotcha,
you might post your SQL stmt,
your table structure(s),
your Access version,
and identify the indexed fields in your table(s).
Please respond back if I have misunderstood.
Good luck,
Gary Walter