How does Access delete work? 1

[fy79]

when data is deleted, where does access store or place it? can it still be retrieve? im doing a project where i want to create something like a recycle bin for access. any help much appreciate it.

 

[nberryman]

The way I do it is to add a field to each of your tables called Deleted and is a yes/no field.

All my objects are based on queries where deleted is no.

This way a user can delete a record by checking the tick box but of course the record is not deleted.

I then have an append query that runs when needed to append "Deleted Records" to an archive table. This is run on an ad hoc basis depending on the size of the database

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com