98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » User Level Security
User Level Security
Resolved · Low Priority · Version 2003
Thu 4 Jun 2009, 10:39Delegate Azlina said...
Azlina has attended:
Dreamweaver 8 Introduction course
User Level Security
I have a database on a shared drive in work. There are 7 people accessing this database with myself as the administrator. I've tried using the User Level Security Wizard and maybe it's just because I'm a bit slow but I cannot get it to work.
I would like to restrict the 6 other staff members' use of the database to just being able to add and view data but definitely not be able to delete anything as it took me many painstaking hours to collaborate all the information. I thought this could be done through their login details to the database but I can't get it to work and I have no idea what I'm doing wrong.
Please help!
Mon 8 Jun 2009, 08:47Trainer Rajeev said...
RE: User Level Security
Dear Azlina
Thank you for your query!
Please refer to the below link which provides the theory as well as practical side to creating user levels and setting permissions.
http://office.microsoft.com/en-us/access/HA101662271033.aspx
It focuses on Access 2007 but the 203 is very similar as long as you know how to access the User Level Security wizard!!
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
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 tip:Zoom feature for queriesIf youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field |
