Sending a record to the theoretical Recycle Bin.

[thetambarineman]

Ho everyone,<br>I'm wondering what the possibilities are of sending a record a theoretical Recycle Bin, i.e.- a dir of my choice.<br>The db is MS Access and i'm using the ADO controls- the only other workaround is possibly for me to back the database up using the filecopy function every time a record is deleted - but even that would involve a confirmation for overwriting the existing db, anyone got any idears???<br><br><br>Thanks in Advance!!<br><br>Paul..<br>

 

[Amiel]

<br><br>Sure.&nbsp;&nbsp;Add a field called 'Deleted'. <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>

 

[pwesson]

Or, if you don't want your table loaded with deleted records, you could create duplicate tables to hold nothing but the deleted records. ie. dbCustomersDeleted

 

[famousb]

or, to expand on the concept of not wanting your tables to hold deleted records, you may not want your database to hold tables with deleted records so you could append to a table in a seperate database that only contains deleted records.<br><br>and to expand further, if you don't want your C: to have a database that contains tables that contain deleted records you could write to a table in a database on a network drive...<br><br><br>sorry, got carried away. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>