Forum home » Delegate support and help forum » Microsoft Access Training and help » Access rights
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access rights
Resolved · High Priority · Version 2007
Reply Mon 7 Feb 2011, 16:14Delegate Chris said...
Chris has attended:
Access Introduction course
Access Intermediate course
Access rights
restricting ability to change data
For upcoming training course dates see: Pricing & availability
RE: access rights
Hi Chris, thanks for your query and apologies for the delay. The simplest method of restricting the ability of a user to change the data in your database is to make it read only. IT usually get involved when different users want different access rights, although you can code specific solutions to this:
http://bytes.com/topic/access/answers/907039-how-set-forms-subforms-allow-edits-property
It's very situational, but as you can see solutions range from the file property level to bespoke coding solutions!
Hope this helps,
Anthony
Thu 17 Feb 2011: Automatically marked as resolved.
|