Need to clone part of a database

[Cameron]

I have been asked to seperate a portion of our database found in Access 2003
to a new database. Essenially, what I have to build is a means through code
to locate all the tables in the primary database that adhere to the entery
year of 2008 and on and move that data to a new database. Is there a way with
code to migrate all the tables over to a new database, and then cycle through
a loop using queries to populate the new database with the data from anything
from 2008 on wards?

The database backend is not all that large but the site would like to
seperate the data in terms of years for record keeping and environmental
regulation purposes and thus regardless of doing queries that would filter
out the data they still (and so would the government auditor) like all the
years seperated into their own database.

 

[Jeff Boyce]

Cameron

You do realize that using a separate database (?do you mean "table") for
each year's data makes the task of querying cross-year trends MUCH more
difficult?

If, despite the added difficulty and knowing that you really should be
keeping all the data in one table, using queries to separate out the "year"
data, you decide to create separate databases (?do you mean tables), then
don't bother "loading" an empty.

Just make a backup copy and remove everything that isn't 2008.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP