user rights without .mdw?

[kordo]

Hi,

Is it possible to create user groups with specific rights (read only, create
and read, create, read and delete) without saving them in an extra .mdw file?
I want to put the .mdb file on an accessible network at my work. The problem
is that everyone who clicks on the .mdb file to start access uses his own
..mdw file which does not have any restrictions. So I am the only one who will
get a password prompt. Or is there any other way to make sure that other
people have to fill in a password to get specific rights?

Thanks in advance,
J.K

 

[Arvin Meyer [MVP]]

You need to understand security better. The MDW file contains users and
groups. It must be associated with a specific database for that database to
be secure. The permissions on each object are stored within the database,
and they are given to users from a specific MDW file. Even if I have an
account in my own MDW, it does not have the same PID as my account in the
MDW associated with a secure database. You have obviously not secured your
database. Read the Security FAQ carefully, and more than once to understand
the security model. Here are some useful links for you:

Security FAQ
http://support.microsoft.com/support/access/content/secfaq.asp

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm

 

[david]

After you have properly secured your database, you
can put the correct MDW file (which will be required
to open the database once it is properly secured) on
the network in the same place as the MDB.

In the same place you can also put a shortcut that users
can click on, pointing to the MDB and the MDW.

(david)