Help - Creating Archive DB and Linking to Current DB

[TigerNoire]

Hi,

I currently administer a massive database to calculate payroll. As of June 30, all wage rates are changing for the new fiscal year. What I need to do is preserve all historical data, hopefully in an archive db,(wage rates, dates worked, hours worked, etc.) and allow for the new rates and new info to be put into the current db. I've read some posts on creating an archive database and linking it with the current database to allow access to archived data. I have not done this before and I'm very concerned about screwing it up and corrupting my current database. Is there a step by step guide somewhere or is someone willing to provide instructions? Does anyone have suggestions on the best way to go about doing this?

Current DB info:
Security exists
Numerous tables with relationships
Numerous queries, forms, reports, macros

Any help, suggestions, comments are welcomed and appreciated. Thank you in advance!!!

TigerNoire

 

[PHV]

all wage rates are changing
No date of application in the rates table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TigerNoire]

I don't have a rates table - no unified way exists for determining rates across departments.