How can I "lock" a record except for one field so it can't be altered? Thanks!!
M michaaal Jun 12, 2004 #1 How can I "lock" a record except for one field so it can't be altered? Thanks!!
A Arvin Meyer Jun 13, 2004 #2 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
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
