Permissions

[Dishon]

I have setup users and permissions but I can't see how they are implamented.
Whenever I open the database it just opens in Admin mode. How do I get it to
open in one of the restricted user modes?

 

[Keith]

I have setup users and permissions but I can't see how they are
implamented.
Whenever I open the database it just opens in Admin mode. How do I get it
to
open in one of the restricted user modes?

Give the Admin user account a password then close and re-open the app. When
prompted, enter the 'restricted' account username. You can then assign that
account a password.

Keith.
www.keithwilby.com

 

[Joan Wild]

I have setup users and permissions but I can't see how they are
implamented.
Whenever I open the database it just opens in Admin mode. How do I get it
to
open in one of the restricted user modes?

There is much more to security than just going to the security menu and
adding users/permissions. The very first step is to create a new workgroup
file. It doesn't sound like you did that. You have modified the system.mdw
that comes with Access and is required for opening unsecured databases.

You should undo what you've done and read up on security before going
further.
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm