Deleting Records in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me a quicker way to delete multiple records in Access?

Currently, I am clicking/highlighting/scrolling through multiple rows in my
table to delete them.

I have around 200,000 to delete.

Thanks if you can help!! Bonnie
 
if the records that you are deleting has an identification like:>1000,
BL001,BL001

DoCmd.RunSQL "DELETE Table.* FROM Table WHERE [Identfication]
 
Hi Bonnie,

How are you deciding what to delete?
A quicker way? Sure try Delete * From [Table Name]

That will delete every row in the table.
 
Can anyone tell me a quicker way to delete multiple records in Access?

Currently, I am clicking/highlighting/scrolling through multiple rows in my
table to delete them.

I have around 200,000 to delete.

Thanks if you can help!! Bonnie
Click to expand...

A Delete query will do this in a snap. If you want to delete all the records
in the entire table, just create a query based on the table and change it to a
Delete query. To selectively delete records, apply a criterion to the query on
the Criteria line.

Be sure to compact the database after you run this, to recover the space
formerly occupied by the deleted records.

John W. Vinson [MVP]
 
Back
Top