Access-Archiving

[salof98]

I have a user that wants to archive information in a database for a time
period. Is there anyway to do this in Office 2007? I'm not familiar with
what they are wanting.

Thanks for all responses.

 

[Jerry Whittle]

Unless the database is bumping up to the 2GB size limit or there are some
performance problems, archiving data is usually a very bad idea. In fact it's
probably better to find the root cause of the performance problem and fix it.

There is no built-in tool for archiving data. You'll have to write an append
query to move the data to another table in another database file then delete
the data. Since this is a two-step process, there's the possibility that
things could go badly wrong, so a backup routine would be a good idea first.

 

[Larry Linson]

I have a user that wants to archive information in a database for a time
period. Is there anyway to do this in Office 2007? I'm not familiar with
what they are wanting.

If I understand your question, you are not asking about saving outdated data
from your database in a separate archive, but keeping a record/archive of
information in a database, accessible chronologically. Access has the
capability to include a date, or date-and-time, field or fields on which you
can search and also other fields on which you can search. Specifically how
you would accomplish this will depend on the details of the information you
have, how you want to be able to access/search it, etc.

If Jerry's understanding was what you meant, then see his response regarding
saving outdated data.

Larry Linson
Microsoft Office Access MVP