How do I secure a record?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to secure a record once I have completed it. Once closed
and then re-opened I want it to be read only and only able to change the data
through password control or an alert pop up or similar. I don't need to
password protect the whole database, just the individual records.

Tom
 
You can't secure an individual record so it cannot be changed if a user has
unrestricted access to the database so he can see and open tables directly.
Provided you have some way of keeping users from getting into the
development environment, what you can do is add a Yes/No field to the table
that will tell whether the record can be modified.
Then, in your forms, use the Current event to lock controls so he can't make
changes.
 
To carry on what Klatuu wrote, once you have setup your db not to allow your
users go beyond your UI, you may want to take a look at:

http://allenbrowne.com/ser-55.html

which allows you to define field level permissions. You can select all
fields in a record to lock the entire record.
 
Back
Top