Different level of users

[shoa]

Hello
Can I set different level of users for a Database Access. For example a kind
of user-administrator (with a password and user name) can have a full access
to a Database access. He can add, delete table, create new queries...
Another kind of users can view, add data into this database but cannot
delete records, or cannot create new table, form.... The third kind of users
can only read or view table content or print report....

Is it possible doing so or there is any way to overcome this problem???
Thank you very any help
S.Hoa

 

[John Nurick]

Hi,

Access provides "user level security" for just this purpose. Because it
offers fully flexible control over which users can do what, it is rather
complicated and very hard to understand at first - but if you don't
understand it properly you won't get effective security. What's more,
it's quite possible to lock yourself out of your own database.

Study the Security FAQ very thoroughly before you start, and make
certain that you have a backup copy of the database.

The following links should take you to the necessary information:

Security FAQ - includes explanations and step by step instructions
http://support.microsoft.com/?id=207793
or
http://support.microsoft.com/support/access/content/secfaq.asp

Security Whitepaper (old, but explains the concepts)
http://support.microsoft.com/?id=148555

 

[shoa]

Thank you for your help

Hi,

Access provides "user level security" for just this purpose. Because it
offers fully flexible control over which users can do what, it is rather
complicated and very hard to understand at first - but if you don't
understand it properly you won't get effective security. What's more,
it's quite possible to lock yourself out of your own database.

Study the Security FAQ very thoroughly before you start, and make
certain that you have a backup copy of the database.

The following links should take you to the necessary information:

Security FAQ - includes explanations and step by step instructions
http://support.microsoft.com/?id=207793
or
http://support.microsoft.com/support/access/content/secfaq.asp

Security Whitepaper (old, but explains the concepts)
http://support.microsoft.com/?id=148555