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]




--
Lorenzo DÃ*az
Cad Technician


"Bonnie" wrote:

> 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

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.

On Oct 25, 1:37 pm, Bonnie <Bon...@discussions.microsoft.com> wrote:
> 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

On Thu, 25 Oct 2007 10:37:00 -0700, Bonnie <(E-Mail Removed)>
wrote:

>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

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]