Topics Search

Delete records from table?

Delete records from table?
Views: 65
how to delete a subset of records within a table ? For example, if I have a particular set of records (table B) that I know they are a subset within a big table A. Both have exactly number of fields, etc. HOW do I delete the same records of table B from big table A.

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?
Sponsored Links:

More topics


Delete not working from table of objIDs

This should be so simple, I don't get it.
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

Delete all records in a field

I am looking to put a Command Button on a form to delete all records in a table. I found a Macro that deletes the whole table but I just want to delete the records. Any Ideals

Specify the Table containing the records you want to delete

Im currently using MS Access 2003.

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 all records in a table?

I want to place code in a click event to delete all records in a table but keep the table for new records. DELETE * FROM Employees WHERE Title = 'Trainee'; seems to have trouble with the asterisk.

Delete records from table in ANOTHER database

at VBA. I would like to implement it to delete all records from a temp table in another database. In other words, I want to write code in Database_A to delete all records from t_temp in Database_B

Problem With Delete Query

I have two tables in access 2000 linked together to isolate the records I want to delete. I have them linked by 3 key elements that would leave no doubt they are the records in question. When I change my view from a select query to a delete query, I get a message that states "Specify table containing records to delete"

Now I get this error:
Single-row update/delete affected more than onen row ofa l inked table. Unique index contains duplicate values

Delete First Record in a Table?

I've got a situation where I need to append data to an empty table that will autonum the records for me, delete the first record of that table, run a series of queries using the table's data without that first record, then delete all the records from that table again to set it up for the next time that event needs to fire.

I'm having trouble figuring out how to delete just the first record from that table automatically as part of the sequence of events.

Error 3086 Simple Access Delete Query

Having problems getting simple access delete query to work. Select works fine but get Error 3086 when I try to delete. I want to delete all records in 1 table if they have matching Date records in table 2. This is my Sql:

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.

The DELETE Operand in SQL for MS ACCESS

DELETE is one of the simpler SQL commands, and can be used to delete rows (or records) permanently from a table. It's very useful if you're trying to purge old data from your records. If you want to archive your records, however, you're better off SELECTing records and saving them to a new table first (which you'll archive), and then DELETEing the same records.

Delete records from a table: Use Find Dups Query & Delete or not?

I have a new database that contains a table called Table_PartNumbers. It contains a list of all the part numbers with all of our customers. In my initial data entry I accidentally duplicated 4 part numbers.

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?