Archive old records

[mbaddar]

Hi

I posted this message in a couple of other forums
and haven't gotten a response yet. Sorry, if you've already seen this in one of the other forums. Basically,
I need to archive all records in a database prior to
year 2000. I'm not sure how this would be done. Do
I need to create a backup database and write a query
to move all the data in this backup?

Any help would be appreciated.
Thanks,
Mbaddar

 

[tlbroadbent]

The easiest method to archive an entire database is to copy the MDB file to another file name or folder. You could also insert the records into table(s) in the same database or another database. You could do this by exporting the table(s) to the other database or even a text file or Excel spreadheet.

If you want archive in the same database, you can copy the table to the clipboard and copy it with another name. You can also use a query (MakeTable or Append) to copy the data.

You'll probably want to create a query to delete archived records from the original table.

The best method will depend on what kind of access you need to provide to the archived data, database size, etc. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[mbaddar]

Hi,

Thanks, that sounds like a nice approach.

MBaddar

 

[Garridon]

Microsoft also provides instructions on their Web site on how to archive old records. I use it to archive closed records. In my case, when the user enters the closed date, then the record archives when the form closes. However, I added one more thing--a backup table and a backup append query. It runs after the archive append runs, so that if any records get deleted that shouldn't be I can recover it.

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com