Archive Question

[jazz123]

I work for an airline, and we use an Access Database to track all baggage claims. The file is getting pretty large, so we want to remove the closed claims from the main table. Is it better to append the closed claims to a new table, or would it be better to export the closed files to an Excel document?

If I choose the option to Append to a new table, can this be done to a second database or just create an additional table in the existing file?

Any help that you can give, I'd greatly appreciate.

thanks!

 

[maxxximaniac]

You can append either way, if you still want to be able to manipulate that closed claim data, I would suggest appending to a 2nd database, an archive.

Just Export to another database.

 

[jazz123]

You can append either way, if you still want to be able to manipulate that closed claim data, I would suggest appending to a 2nd database, an archive.

Just Export to another database.

Is this done through a query? I'm not sure how I would do this.

 

[maxxximaniac]

Do a Make table query with the closed claim criteria,
Then do a delete query and erase it from the main table.

Create a New DB, and drag that table into the new one. Or Right click the table, and click export, then click on your new DB.

Erase the archived table from the Main DB.

 

[jazz123]

In the query I'd like to move all claims that have been closed for at least 30 days. I'm not sure this is possible, because I'm not sure that a date is tied to the "status" item in the table. The options are either open or closed. Putting Closed as the criteria is easy. Is there anything in the database that would specify the date it was closed automatically? Or, do I need to add a line for "Date Claim Closed"?

 

[maxxximaniac]

When you append to a new table for the CLosed items, make a new field in the query

Date: Date()

That will append the current date.

 

[jazz123]

I've got an archive dadabase set up and have been able to transfer over all claims that have been closed for 30+ days. I'm going to want to do this periodically. How do I export to the new database, without the existing archive table being overwritten. Right now, I'm exporting it to a different table, and them copy and paste the new records to the archive table.

Also, is there any way to automate this process? Meaning I'd like the query to run automatically every so many days.

 

[jazz123]

I've got an archive dadabase set up and have been able to transfer over all claims that have been closed for 30+ days. I'm going to want to do this periodically. How do I export to the new database, without the existing archive table being overwritten. Right now, I'm exporting it to a different table, and them copy and paste the new records to the archive table.

Also, is there any way to automate this process? Meaning I'd like the query to run automatically every so many days.

Anyone know the answer to this?