Problems Deleting Records

[Anita]

In Access 2000, I have a user with several databases that
exhibit the following behavior:

In tables with over 5,000 records, when he opens the table
in form view and selects all the records, then hits delete
key(or uses delete toolbar button), the hour glass (wait
cursor) appears and never goes away. He must end task on
Access and restart it.

When he restarts and goes back to the same table, all the
records have been deleted.

Any ideas on how to overcome the need to end task each
time would be greatly appreciated.

 

[John Vinson]

In Access 2000, I have a user with several databases that
exhibit the following behavior:

In tables with over 5,000 records, when he opens the table
in form view and selects all the records, then hits delete
key(or uses delete toolbar button), the hour glass (wait
cursor) appears and never goes away. He must end task on
Access and restart it.

When he restarts and goes back to the same table, all the
records have been deleted.

Any ideas on how to overcome the need to end task each
time would be greatly appreciated.

Has this database been Compacted? If this operation is performed
frequently, the database will grow and grow until it hits 2 GByte and
crashes.

I'd strongly suggest creating a Delete query (DELETE * FROM tablename)
and executing that query rather than using the table datasheet, or
even a form datasheet. It sounds like the delay may have to do with
the user interface, not the mechanics of deleting the records.