archive data from tables to another db

  • Thread starter Thread starter Vito Corleone
  • Start date Start date
V

Vito Corleone

Hi All,


I am having a POS application was developed in MS Access
97. How can I move all the data in the current tables to
a safe place without losing data integrity and must be
able to use in the near future without a lot of hashless.
After all the data were moved, all the tables must be
empty so I can start to enter new data into them.

What I need is to move all the data of last year 2003 to
some places without losing data integrity and at the same
time the tables must be emptied so I can start to enter
fresh new data of this year?

Can you give me some suggestion? or article number on
microsoft.com?

Thank you very much

Vito Corleone
 
The Don,

There's no need to move the data anywhere. Access can handle all the data
you're talking about. Just add an extra boolean field, called "Active", to
all tables (except the lookup tables). The DefaultValue for this field =
True.

When you archive your data, just run a query for each table (in the correct
order - subtables first) to set the Active field = False.

Ensure that your forms only return data where the Active field = True. If
you like, you can put a checkbox on all your forms, to allow the user to
select between active and inactive (archived) data.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top