Archiving old tables in access

[Guest]

Hi can anyone tell me if it is possible to archive old tables in a database.
I am using Access 2000 and do not want to see tables from 3 years ago
everytime i open up my database.

 

[BruceM]

Base the forms and reports on a query that uses a parameter in your
DateField:

DateAdd("yyyy",-3,[DateField])

This assumes you are using forms, and that you are not entering data
directly into tables. Even if you are entering data directly into tables
(which you should not be doing), you can use the query instead of the table.
You won't see records from longer ago than 3 years, and it will look just
like a table. A better choice if you like the look of a grid would be to
make a form based on the query, and to set its default view to Datasheet.

Unless your database is approaching the 2GB limit, or there are performance
issues that can be attributed to the size of the table (and that cannot be
solved through improved database design), there is probably no reason to
move records to another table. If it is approaching that 2GB limit the
other table will have to be in another database.

 

[Guest]

Are you talking about records or tables? Do you have something like a 2004,
2005, 2006, and 2007 tables? If so, your database design has some serious
problems and I highly I highly recommend getting some relational database
training or reading "Database Design for Mere Mortals" by Hernandez before
proceeding any further on this database.

If you are talking about records in a table and those records have a
Date/Time field, you could create a query that doesn't show records more than
3 years old. Then use that query to populate any forms or reports where you
don't want to see the older records.

For example you could have the following in the field of the query:

TheYear: Year([YourDateField])

And the criteria would look something like: