In a table of MS Access 2010, is it possible to lock certain fields so that the user can only see those fields but not edit it?
Reply from Richard Rost:
Nope. Your end users shouldn't be in your tables anyway. Use a form and just show the user the fields you want. You can set the LOCKED property for the individual fields, or ALLOW EDITS, ALLOW ADDITIONS, and ALLOW DELETIONS properties of the form.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
599CD Free Demo Lessons.
