Locking records after an event

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Can anyone tell me if it's possible to lock certain
records or part of a table. For example if al the data
has been entered for week 1 and this data has been
processed, I want it to be frozen/ locked so week 1 can't
be changed anymore and the data for week 2 can be entered.

This should happen per user.
 
Can anyone tell me if it's possible to lock certain
records or part of a table. For example if al the data
has been entered for week 1 and this data has been
processed, I want it to be frozen/ locked so week 1 can't
be changed anymore and the data for week 2 can be entered.
Click to expand...

Long answer: using Access security will do this, but it's an involved
process and all the steps need to be done correctly as you can lock
yourself out of your own data, or leave it un
 
Can anyone tell me if it's possible to lock certain
records or part of a table. For example if al the data
has been entered for week 1 and this data has been
processed, I want it to be frozen/ locked so week 1 can't
be changed anymore and the data for week 2 can be entered.
Click to expand...
The long answer is that Access security can do this, but be prepared for
some intensive reading and learning. It is easy to make a mistake and
either lock yourself out of your own data, or leave the database
unprotected.

An easier way is to base your forms on queries, and simply not re-present
completed data to the users that are not allowed to see it. It is a good
idea to base all forms on queries rather than tables anyway, so just
putting in a criterion like

WHERE WeekNumber < ThisWeekNumber
AND DataChecked = TRUE

will do nicely.

As usual, the forms you give to managers (as opposed to the data entry
bodies) should have AllowEdits switched off.

Hope that helps


Tim F
 
Back
Top