suggestions & examples of setting up different levels of security?

[Johnny0123]

hi,

I wanted to setup different levels of security in the access database. For example level one allows user read-only, level two gives addition rights and limit what can be files or forms can be added to or changed. Level three is full access to everything. I might have a couple of more levels in between 2 and 3. Im really not sure how or where to start with this so any suggestions or examples would be great!

Thank you,

-John

 

[straybullet]

check out

http://tek-tips.com/faqs.cfm?fid=3893

Let them hate - so long as they fear... Lucius Accius

 

[assets]

I Have justed added a FAQ to the HOW TO. It is designed to have your own security. I have used from different area ONLY seeing there data (all data is stored ion the table). You can use this also to limit forms etc. eg have fifferent form for different users.

Never give up never give in.

There are no short cuts to anything worth doing