Delete records from table?
I wish I can select the result directly from table A. In other words, I can NOT query out to get the result table B from table A, because the criteria is NOT simple. My result of table B had to get from joining different ways to get the result.
My question is HOW do I delete records from a bigger table A for the same EXACT # of records in another smaller table B?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a table of object ID's
I want to delete the records in a much larger table. but I only want to delete the records found in my To Delete table.
When I add both tables into the query design, link them, then try to delete from the master table, I get "can't delete from specified table
I'm experiencing this error: Specify the Table containing the records you want to delete when deleting a records.
I have 2 tables. Table A is my reference IDs to delete from Table B.
When I link now this 2 tables, then run the query, it prompts me Specify the Table containing the records you want to delete, yet I have already link the Table A which is my reference IDs to delete in Table B.
How to resolve this?
Here's the syntax from MS Access (SQL View)
DELETE DISTINCTROW TABLE_B.ID_A
FROM TABLE_A INNER JOIN TABLE_B ON TABLE_A.ID_A = TABLE_B.ID_A
Now I get this error:
Single-row update/delete affected more than onen row ofa l inked table. Unique index contains duplicate values
I'm having trouble figuring out how to delete just the first record from that table automatically as part of the sequence of events.
DELETE [Daily DB].*
FROM Max_Date LEFT JOIN [Daily DB] ON Max_Date.X_DATE = [Daily DB].X_DATE;
Using Access 2007, DB + Tables are not read only, I am the creator and I can delete records manually from the table.
Can I just delete the records from the table (select then delete) or should I get rid of them by creating a Find Duplicates Query, convert it to a Delete Query and take care of them that way?
At this point nothing bad will happen to my database if I just click and delete the 4 extra records. All the part numbers have a unique ID and the database is so fresh that there aren't any records in any other tables that reference the duplicates.
But, since I'm trying to learn 'proper' technique this go around, I was wondering what proper steps should be followed?
I found this link below but I just don't quite understand if this something you always want to do or it is okay to just delete records if there is no chance of database corruption?