permissions?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i set up opening my database with a) full admin permissions and B)
limited user permissions . Is there a quick method to switch between the two.
 
It's simplest just to create two Access user accounts with the different
permissions, and log in using one or the other (assuming you're using
Access user-level security). If security isn't that important, you can
set up two shortcuts, using the /user and /pwd switches to pass the
log-in information.
 
First make a copy of the database and place in a safe place in the event you
somehow make an error in this process and need to recover.

The is a security wizard built-in Access that will walk you through the
steps. Starting with Access 2000 implementing Security is a little easier.
There is an article located at the Microsoft Knowledge Base on Implementing
Security in Access. Read this thoroughly first and follow the directions
exactly. Make sure you assign yourself as an Admin, so that you can go in
and make changes and add new users. If you don't. You've locked yourself out
of the database.

If all goes well you will create a secure database. Be aware that when you
logon for the first time, you only type your username as no passwords have
been assigned. You only assigned username and PIDs. Be sure you write down
this information and then store it in a safe location. The Security
Whitepaper will explain it all.

Good Luck
 
Back
Top