[AccessD] Delete query... fast ... deleting from datasheet view ... slow

Gustav Brock Gustav at cactus.dk
Mon Jul 4 03:11:35 CDT 2011


Hi William and Stuart

I don't think that's the reason, but it is similar: Access walks through the recordset (which may be filtered) and copies all records to a temp table to hold them in case you - when asked later via the GUI - choose to undo the operation. Only if you choose to confirm the deleting of the records, this actually takes place.

/gustav


>>> stuart at lexacorp.com.pg 03-07-2011 23:56 >>>
A SWAG: 
Because Access can't tell that all the records are selected. It has to step through the rows 
and checking the "selected" attribute. That means that it can't implement a simple "Delete * 
>From tblA" but  has to specify each of the records separately for deletion.

-- 
Stuart

On 3 Jul 2011 at 17:23, William Benson (VBACreations. wrote:

> Why is a query that deletes all records from a table so fast in
> comparison with a manual delete operation on a table that is opened in
> datasheet view?





More information about the AccessD mailing list