Archiving Records

[Tom]

I need to create a macro/function that allows me
to "archive" records.

Basically, I need to...:
- copy a record from Table1
- paste this record into Table2
- deleted this record from Table1

Naturally, each record contains multiple fields.

Does anyone have an idea how to "move" an entire record
within Access across 2 tables?

Any ideas as to how I should solve this problem are
welcomed!!!

Thanks,
Tom

 

[Tom Ellison]

Dear Tom:

What you suggest can certainly be done, but what would be the purpose? If
the tables would be in the same database, then there is a simpler, very
quick, and easy way to do the same thing. Simply put an "Archived" yes/no
column in the table. Then, write queries so that, when appropriate, you see
only those rows that are archived, or only those that are not. This not
only has the advantage of simplicity at this level. If another table is
dependent on this table, or if this table is dependent on another table,
then you don't need to multiply relationships. Also, if you have a program
to search both "current" and "archived" data you need only search the one
table, ignoring "Archived".

 

[Tom]

Tom:

I think you're having a point here... I'll discuss it w/
some team members and see if this approach is feasible.

Thanks,
Tom