Simple Delete query

[VegaLA]

Hi all,
i'm having problems deletign data from a local table with a query that *should* delete a range of records selected from another query. The code is below:

DELETE tblFinal.*
FROM qry0555SELInvref LEFT JOIN tblFinal
ON qry0555SELInvref.INVREF = tblFinal.INVREF;

Now I have a similar query that is pretty much the same but the range to delete was only 1 record in that particular query, this one pulls up 15 records, not that it should matter. I manually deleted a record from this range to make sure that the table was'nt protected and the record deleted without problem.
The error message is : Could not delete from specified tables.
I am using Acccess XP with Windows 2000.

So does the problem lie with the number of records it can delete from a select query in one hit ? That can't be right ?
Any ideas ?

Thanks in advance,
Mitch..........

 

[bvan]

Do you have a primary key in both tables? The lack of a primary key often makes recordsets not updateable.

 

[VegaLA]

Thanks Bvan.
I have now added new fields to both tables, an Autonumber ID field that is now the primary key. Treid to run the delete query but i'm getting the same message.
This is weird !!!

Found it !!

For anyone else who encounters this I found the solution here........

http://support.microsoft.com/kb/240098/