Samantha,
1. Create a new workgroup.
2. Join that workgroup.
3. If you created the database you were interested in
without using a new workgroup, then create a new blank
database, and import all of the components (tables,
queries, etc.) into your new blank database.
4. After importing the components into the new blank
database, go into the Security options of that database,
and make a new user account for yourself. Make that user
account a member of the Admins workgroup.
5. Now close the database, and log on using the user
name Admin, and no password.
6. In the security permissions area, in the change
owner section, change the owner of the database, tables,
queries, macros, reports and modules of the database to
the new user account name you created for yourself. Now
close the database, and reopen it as the Admin user name
without a password. Go to the Security options under
Tools, select the User Security Level Wizard and choose
the secure your database tables, queries, macros, reports,
and modules of your database.
7. The wizard will create a new secured version of
your database automatically, and leave you an unsecured
version of your original.
8. Next you would log on to your new secured version
of your database, create groups an permissions for those
groups. Create new users, and assign them to the
appropriate groups. Please note, in your new secured
database, the group "Users" will have no permissions to
any tables, queries, reports, macros, or modules. This is
because this is a secured database, and no permissions
have been assigned to any group except the Admins group.
Instead of using the Users group, create new groups and
use them, it will make it easier for you.
Now, I know that the information above is very useful
from my own experience. If you have a database that you
have created user group accounts for already, but did not
create that database after joining a new workgroup other
than the one that comes with Access, I recommend doing
what I have described above. Otherwise if you did create
the database you have now after creating and joining a new
workgroup, just make sure you have a user account created
for yourself, and that that user account is a member of
the Admins group. Then just start at step 5 listed above
and go on through the rest of the steps to secure your
database.
I know the above mentioned methods will work, and I
hope that I have helped you.
Have a nice day.
Casey
>-----Original Message-----
>i have built a database and need to use user level
>security, I've read all the books and still dont
>understand how to do it.
>I have created the workgroups and assigned permissions to
>them but dont know how to get the passwords to activate.
>help me please!
>
>.
>
|
Similar Threads
