Saving Deleted Entries

  • Thread starter Thread starter John C.
  • Start date Start date
J

John C.

I have a database which allows users to delete entries
they have previously made.

I want to transfer these records from the current DB to
another DB to archive/preserve these entries. I'll trap
this in the Form_AfterDelConfirm routine.

The deleted DB will have the same fields, plus two new
ones, to record userid and machine id.

I have not referred another DB outside of the current one
in use. Is there a global command to transfer all the
fields at once?
 
While I realize it does not directly answer your
question, have you considered a simpler approach of
keeping the records in the existing database. There are
all kinds of reasons that this is preferrable.

The way that I like is to create a "mirror" table and
call it something like
tblDeletedTheNameOfTheOriginalTable. You can add the
UserID and MachineID to the new table. Then use an
INSERT statement into the new table as you DELETE the
record from the original one.

If this sounds like a good direction and you need help
with the syntax reply back. Likewise, if this approach
will not work and you really want to create a second
database and call it up whenever a user deletes there are
ways to do this, but they are more cumbersome than the
above method.

Either way, let me know.
 
I would prefer to refer to another DB all together.

The DB will be located in the same folder/directory as the
originating DB.
 
Back
Top