Stuart McLachlan
stuart at lexacorp.com.pg
Sun Jul 3 16:56:19 CDT 2011
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? > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >