Need to protect data input

  • Thread starter Thread starter Lynniebird
  • Start date Start date
L

Lynniebird

As employees update information in the database, I need to make sure the
information cannot be changed. How can I do this?
 
Lynniebird said:
As employees update information in the database, I need to make sure the
information cannot be changed. How can I do this?
Click to expand...

So you want your users to be able to update data but not change it? That
makes no sense, would you care to elaborate?

Keith.
www.keithwilby.co.uk
 
Once the data is entered, it needs to be secured so that no changes can be
made. A new entry will have to be made from that point on--no changes can be
made to the data after it is entered. Project tracking is very critical in
this industry and we must protect from accidental deletes.
 
Lynniebird said:
Once the data is entered, it needs to be secured so that no changes can be
made. A new entry will have to be made from that point on--no changes can
be
made to the data after it is entered. Project tracking is very critical
in
this industry and we must protect from accidental deletes.
Click to expand...

Forms have an Allow Deletes property. Set it to No.

To "lock" the contents of a record I would suggest setting the content of a
Boolean field in the form's Before Update event. Then in your form's
Current event you would set the form's Allow Edits property based on the
Boolean field value.

Naturally, you would not want to allow access to the Boolean field to your
users.

HTH - Keith.
www.keithwilby.co.uk
 
Back
Top