Security Level

[SF]

Hi,

I have develop a database now in user by 3 departments. This database work
fine except it does not have any security level setting. The management
asked me to add this feature for example setting up 3 groups (users,
department head and Head of orgnazation). Users can do certain thing where
as Department Head can do certain thing that Users cannot do...

I cannot find a way to setup this security level. Could somebody give some
ideas. Does this related to Access Security (Log on) or it is a separate
setup?

SF

 

[Guest]

You can use the User level security wizard, to set this up,

More information can be found here:

http://office.microsoft.com/en-us/assistance/HA011381101033.aspx

and the following pages, by clicking next at the bottom of that page

Hope this helps

martin

 

[Joseph Meehan]

Hi,

I have develop a database now in user by 3 departments. This database
work fine except it does not have any security level setting. The
management asked me to add this feature for example setting up 3
groups (users, department head and Head of orgnazation). Users can do
certain thing where as Department Head can do certain thing that
Users cannot do...

I cannot find a way to setup this security level. Could somebody give
some ideas. Does this related to Access Security (Log on) or it is a
separate setup?

SF

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.

 

[Arvin Meyer [MVP]]

You will want to use Access User-level security. A security faq is available
at:

http://support.microsoft.com/support/access/content/secfaq.asp

Read it carefully several times. Proper security is complex and you could
easily lock yourself out. When first setting everything up, make sure that
you have a backup for everything.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

In addition to the advice you have received from others, check out Access MVP
Lynn Trapp's page:

http://www.ltcomputerdesigns.com/Security.htm

In particular, check out the link for "The 10 Steps Summarized".


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________