User Level Security

The UK's most regular instructor-led training courses.
Training information: microsoft.access.courses · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

2 posts

ReplyThu 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!

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	5		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

870 posts

ReplyMon 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

· Microsoft Access Mistakes to Avoid
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Access 2007 Is All About Systems!!
· Reasons to Consider Microsoft Access Training

Please browse our web site to find out more about
microsoft.access.courses and other Microsoft training courses.

Access tip:

Zoom feature for queries

If 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

View all Access hints and tips