Security Level

#1 (**permalink**) 28-Jul-2006, 08:29 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12419-security-level.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12419
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

#2 (**permalink**) 28-Jul-2006, 08:29 AM

You can use the User level security wizard, to set this up,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12419

More information can be found here:

http://office.microsoft.com/en-us/as...381101033.aspx

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

Hope this helps

martin

"SF" wrote:

> Hi,
>
> I have develop a database now in user by 3 departments. This database work
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12419
> 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
>
>
>

#3 (**permalink**) 28-Jul-2006, 08:29 AM

SF wrote:
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12419
> 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.

--
Joseph Meehan
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12419

Dia duit

#4 (**permalink**) 28-Jul-2006, 08:29 AM

You will want to use Access User-level security. A security faq is available
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12419
at:

http://support.microsoft.com/support...ent/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

"SF" wrote in message
news:OSiMcEMnGHA.4636@TK2MSFTNGP03.phx.gbl...
> 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...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12419
>
> 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
>
>

#5 (**permalink**) 28-Jul-2006, 08:29 AM

In addition to the advice you have received from others, check out Access MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12419
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/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12419

"SF" wrote:

> 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