Setting Security Levels

[Guest]

I am needing some information on setting security levels for multiple users
in a shared database. I am trying to figure out how to set myself up as the
administrator with full control and ownership of the database and set up
other users for basic use (data entry, correcting records, etc). Can anyone
help shed some light on this for me?? Any info would be greatly appreciated.

 

[Joseph Meehan]

I am needing some information on setting security levels for multiple
users in a shared database. I am trying to figure out how to set
myself up as the administrator with full control and ownership of the
database and set up other users for basic use (data entry, correcting
records, etc). Can anyone help shed some light on this for me?? Any
info would be greatly appreciated.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Guest]

from Hong Kong Rainbow01

here my experience :

1) create a table for user access level. eg. AllowEdit, AllowAddNew,
AllowView, AllowPrint, AllowDelete, Ranking/Post
2) create a login form, after user login, check his access level, say if his
rank is supervisor, u can enable what command button that u want, say if his
rank is clerk, u can disable what command button u want

"Kim" 來函：

 

[shay]

hey kim