How to specify the table containing the records you want to delete
I have a table with numerous records in it, and am attempting to delete certain records that have been selected from it. It gives me following error message saying "Specify The Table Containing The Records you want to Delete", So please let me know how do I create a record deletion system within my MS Access project so that I can store a copy of updated records into a temporary table before deleting them from a table.
Re: How to specify the table containing the records you want to delete
Never tried to delete using a join; I assume that that is where the problem is. Although I also generally don,t include column names because you're deleting an entire row, not just data within those rows, a Parameter and ask the user for the Parameter value since the Table is not in the FROM clause. I'm not sure how your tables are set up. If you have set up relationships to tblPersonalInfo and have set Cascade.
Re: How to specify the table containing the records you want to delete
Unfortunately none of these solves the problem I am having. It still does not know what table I was to delete from. I copied and pasted your statement below into the SQL window, and was able to perform the deletions. Changes in the Microsoft Jet database engine included with Microsoft Access 2000 cause the program to handle the SQL.
Re: How to specify the table containing the records you want to delete
To resolve this error, set the query's UniqueRecords property to No by following these steps:
- Open the select 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 No.
- Save the query, close it, and then run the query. Note that you may now update the data in the query.
SOURCE:http://support.microsoft.com/?id=207761