make table in access 2003 to keep archived records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make a table to hold archived records. I want to send archives from
original table to a new archived table.
 
Do you want to select records to archive?

If so, you could just do this:
1. Select the table in the database window.
2. Copy (Ctrl+C).
3. Paste (Ctrl+V).
4. In the dialog, answer "Structure Only", and supply a name for the new
(archive) table.

This gives you a new, empty table, just like your previous one. If the
original table had an AutoNumber field, you want to change it to a number
field, so:
5. Open the table in design view.
6. Select the AutoNumber field.
7. Change it to a Number field.
8. Save.

To transfer a record to the new table:
1. Select it in your original table.
2. Choose Select Record on the Edit menu.
3. Copy (Ctrl+V).
4. Open your new archive table.
5. On the Edit menu, chooose Paste Append.
6. Delete the record from your original record.

If you want to move records programmatically instead of selecting them
manually, see:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html
 
Back
Top