By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

Solution: field-level permissions in Access

P: n/a
Access does not have true field-level permissions, but I was recently asked
to set up a database where some fields would be locked and others not. The
idea was to allow the user who created the record to make changes, or permit
changes only while the record was new (say for one hour), on a
field-by-field basis, and let the manager change the permissions at runtime.

A custom property on the field, made this simple to implement and
maintance-free. Details and downloadable example in:
Field-level Permissions in Microsoft Access
at:
http://allenbrowne.com/ser-55.html

While it is not true security, it is an adequate padlock for many
applications, and will certainly help avoid unintentional alterations.

This question is not asked often, but hopefully the sample will help some
poster searching for a way to do this.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.