All Access Database locked instead of locking only one?

R

RB

I have MS Access 2003 and I wish to lock one of the access databases with
username and password. There should be two types of users. 1. Admin and 2.
Users with Read only access to this particular Access database.
I tried achieving this by going into MS_ACCESS and TOOLS -> Security ->
User-Level Security Wizard.

I was able to create these two users.But, if I open any other access
database it asks me to enter the credentials - user name and password which
should not be the case.

Can anyone help me with this ?
 
J

John W. Vinson

I have MS Access 2003 and I wish to lock one of the access databases with
username and password. There should be two types of users. 1. Admin and 2.
Users with Read only access to this particular Access database.
I tried achieving this by going into MS_ACCESS and TOOLS -> Security ->
User-Level Security Wizard.

I was able to create these two users.But, if I open any other access
database it asks me to enter the credentials - user name and password which
should not be the case.

Can anyone help me with this ?

Workgroup Security has two portions: users and groups and passwords are
defined in a .MDW file, managed through the Workgroup Administrator; and
security on database objects is managed in the database itself. I.e. the
Workgroup file defines a user named Admin with a password, and the database
defines Admin as being a powerless user unable to do anything (if you've done
it right).

What's happening is that you have set up the default SYSTEM.MDW with usernames
and passwords - and Access uses that workgroup file for all its databases!
Each database (or each group of related databases, sometimes) should have *its
own* .mdw file.

Download the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Study it carefully. Get a good night's sleep. Study it carefully AGAIN. It's
very easy to do security wrong (as you have); it's more than likely that
you've got other problems you haven't hit yet!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top