Logon and Logoff

[Markus]

Hallo

I hope some one can help me setup the security function in access with the
wizared but now i face with the problem when there is a shift change people
would have to exit the access and enter again to be able the change who is
login on is there a way i can just have a logoff butten and it comes up with
the signon screen again

Thank you

Markus

 

['69 Camaro]

Hi, Markus.

when there is a shift change people
would have to exit the access and enter again to be able the change who is
login on is there a way i can just have a logoff butten and it comes up with
the signon screen again

No. Not if user-level security is applied to the database. If a "home
grown" security scheme is applied, then a "Log Off" button could be used in
this scenario. However, we don't recommend "home grown" security for Access
databases, because such systems are so easily bypassed.

For security reasons, one must authenticate with a valid User ID and
password _before_ Access can open the database with the user's appropriate
permissions. If the database were already open and the "next" user had more
restrictive permissions on objects and these objects were already open, Jet
security can't automatically close the "unauthorized" objects when the next
user "logs on." The next user would have all the permissions of the
previous user for all open objects.

To change users when the shift changes, the current user needs to close the
database so that the next user can authenticate with a User ID and password
and Jet will apply the user's appropriate permissions when opening the
database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)