How can I "lock" a record so it can't be altered?

  • Thread starter Thread starter michaaal
  • Start date Start date
michaaal said:
How can I "lock" a record except for one field so it can't be altered?

Thanks!!
Click to expand...

The two approaches that come to mind are to create two linked tables one
with the field you want to allow changes and all the other fields in the
other. Secure the second table using user level security.

Another approach (far less secure) is to hid the table and all forms
except one and on that form only allow edits to that one field using field
properties.

There may be other better solutions.
 
michaaal said:
How can I "lock" a record except for one field so it can't be altered?
Click to expand...

By implementing User-level security, you can deny direct permission on the
tables, allowing access only through forms. In a form you can easily lock
any part of it that you wish. See the security FAQ:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top