Query Creates Read-Only Recordset
- From: "bhikku" <bhikku@xxxxxxxxxxx>
- Date: Tue, 29 Nov 2005 16:20:57 -0800
I want to delete a set of records within a table and I am using records from
another table as a reference. Table A contains the records I want to delete.
Table B contains the subset of records I'm using to identify the target
records. I have full access rights to both tables but when I run the query
"SELECT tblA.* FROM tblA INNER JOIN tblB ON tblA.ItemNo = tblB.ItemNo"
I get the error "operation must use an updateable query".
If Table A contains 100 records and I want to delete 50 specific records,
and Table B contains only those 50 records that match the target records in
Table A, how to I use Table B to delete the records from Table A?
Thank you for any help!
b
.
- Follow-Ups:
- Re: Query Creates Read-Only Recordset
- From: pietlinden
- Re: Query Creates Read-Only Recordset
- Prev by Date: Re: Outlook Toolbar in Access
- Next by Date: Re: MS Access 2003 problem
- Previous by thread: Outlook Toolbar in Access
- Next by thread: Re: Query Creates Read-Only Recordset
- Index(es):