Logging deleted records

[DevinM21]

I have an Idea, Tell me if this is possible with Access.

I have a front end Databse file and a backend filr, backend has two tables, Front end has Main form for the first table and subform for the second table. Thinking of creating a nother datbase file with two of the same tables in it, but with no records yet. This is gonna be for deleted records. I'm thinking of putting a button on my form that will link my form to the deleted tables so you can work with them then switch back to working with regular tables with another button. Is this possible? If so, i think this would be cool. I can probably figure out everything except the linking of the two tables with VBA Code.

 

[DCrake]

Seems a bit of an overkill to me. Why don't you just have another filed in the table that denotes if the record is deleted or not. This can be a boolean field that holds a true/false value. Then is the user deletes a record it just changes its status to False. Then if the user then subsequently select a deleted record a message box appears stating that this record is dead.

David

 

[tehNellie]

I'd agree with David.

If you really wanted to you could create archive tables in your existing database file, there's no need to create a new database file but I'd still go with David's suggestion first unless there's a pressing need to archive off records out of the main table.

 

[DevinM21]

Ok Great Idea, That seems like less work. I'll do that. Thank you