You need to ensure that users do not have direct access to the tables or
queries. All data entry should be via forms.
You would need a field in the relevant table (a yes/no field, or a datetime
field for 'released').
In your form where data is editted, you would make the control bound to this
field only visible for the Admin/supervisor user (note that you should not
use the built-in Admin user).
In the open event for the form, you would check the status of this field and
set the allow edits property for the form to no accordingly.
--
Joan Wild
Microsoft Access MVP
"jeffrey" <(E-Mail Removed)> wrote in message
news:01d601c36810$c077ada0$(E-Mail Removed)...
> I am working on a database in which users can enter
> data/modify data however, at a certain point it is
> released/approved and I want to elminate any additional
> changes once that happens (except for permissions to the
> admin). Should I try creating a new table - or query to
> limit changes?
>
> Thanks.
|
Similar Threads
