I have read through most of the 'Record Locking' posts I could find but still would like some clarification on my issue.
I am creating a database for tracking staff absences. The HR department want it to be possible for each staff member (over 500) to enter details of their absences and then have managers go in and validate/approve the absence. The issue I have is in relation to ensuring that only one person is accessing an employee record at a time.
Effectively at any time there could be up on 16 people trying to access a particular record at any one time and I want to limit this to just one person at a time, the 16 being
the staff member
up to 5 levels of manager above him/her
any of 10 people in HR
At the same time I do not want to stop the record from being included in reports even if it is being edited by someone.
The database b/e is 97 with front ends required in 97 and 2000 since both versions are in use in the company.
Essentially what I want to know is, is it just a case of setting the record-locking to 'Edited Records' or will it require further work. Also do you set the locking through the Tools/Options/Advanced or on each particular form. Also does this locking actually stop the opening of the record a second time or just stop the second user saving changes?
I am creating a database for tracking staff absences. The HR department want it to be possible for each staff member (over 500) to enter details of their absences and then have managers go in and validate/approve the absence. The issue I have is in relation to ensuring that only one person is accessing an employee record at a time.
Effectively at any time there could be up on 16 people trying to access a particular record at any one time and I want to limit this to just one person at a time, the 16 being
the staff member
up to 5 levels of manager above him/her
any of 10 people in HR
At the same time I do not want to stop the record from being included in reports even if it is being edited by someone.
The database b/e is 97 with front ends required in 97 and 2000 since both versions are in use in the company.
Essentially what I want to know is, is it just a case of setting the record-locking to 'Edited Records' or will it require further work. Also do you set the locking through the Tools/Options/Advanced or on each particular form. Also does this locking actually stop the opening of the record a second time or just stop the second user saving changes?
