How do I delete multiple rows or records?

[davidg47]

Is there a way to select several rows of records in a datasheet view of a table and delete all of the selected records?

Every time I try to delete more than one record at a time, I get the following message: "The Micorsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time."

Then it will let me delete one record out of the selection.

I am the only one in that particular table at the time I am trying to delete the record.

Thanks in advance for your help...

 

[neileg]

It's not good practice to manipulate the data in the table directly. You would normally use a delete query to delete records.

 

[davidg47]

OK, great! Can you give me an idea of the kind of query I would need to delete all the records in a given table?

 

[gijskerstens]

delete * from "tablename"