|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How can I protect a field (column in a table) from data entry?I need to protect a Y/N field from myself essentially. I do not want this
data changed. How do I protect the field so that I can view only but not edit. Don't do any data edits in the table. Use forms for all data interaction.
You can set the Locked property of the control bound to the Y/N field to Yes to prevent edits. -- Show quoteHide quoteJoan Wild Microsoft Access MVP Lisa wrote: > I need to protect a Y/N field from myself essentially. I do not want > this data changed. How do I protect the field so that I can view > only but not edit. Lisa wrote:
> I need to protect a Y/N field from myself essentially. I do not want In the table you cannot. However, you could create a SELECT query that has > this data changed. How do I protect the field so that I can view > only but not edit. all the fields from your table. For the field you want to protect instead of just having the field name in the query grid wrap it in an expression. FieldName: [TableName]![FieldName] + 0 The result in the query grid will be identical to what you see in the table but since it is based on an expression this particular column will be read only. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 
Other interesting topics
User level security-- do not have necessary permissions
restrict combo box selection depending on user Opening a previously secured database mapped network drive and security error Tab Change Passwords how to change a name in "msysaccounts"? Programically redirecting to different mdw files An easy solution??? Folder permissions... Can't open Secured Access 2003 Database in Access 2007 Secure back end database |
|||||||||||||||||||||||
