Hello,
I am building a db in Access 2010 to replace a payroll application. There are several tables that contain employee information, job information, etc. which are all referenced by the payroll table. Employees enter their information daily via a form and can change any of their information throughout the week. Once a week the hr person will run a report to finalize the payroll information. What I need to do is find a way for the hr person to lock all employees out of the previous records once payroll is committed so nothing can be changed after the week is up. I have been looking for a way to partition the payroll table so that older data can be easily moved to a locked partition but I am not having any luck finding information. Are partitions possible in Access? Any ideas of how I can make this work?
Thanks,
Nikki