Share the database with Security control

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

Guest

I have design a database and set up the user and group permissions. But once
I delete the .mdw file (not the default one), it will automatically open the
database with default mdw file.

My question is I want to share the database with other user. Each user has
different permissions. They can download the database and the workgroup file
to their local drive. They can open the database only with a permitted
account which stored in workgroup file. (If the mdw file was deleted, the
database can’t open). How can I do that?
 
Lone said:
I have design a database and set up the user and group permissions. But once
I delete the .mdw file (not the default one), it will automatically open the
database with default mdw file.
Click to expand...

Then it was never secured properly. A properly secured file cannot be opened
with any other MDW file.
My question is I want to share the database with other user. Each user has
different permissions. They can download the database and the workgroup file
to their local drive. They can open the database only with a permitted
account which stored in workgroup file. (If the mdw file was deleted, the
database can't open). How can I do that?
Click to expand...

Secure it correctly and that is the behavior you will get. Try the
instructions that Joan Wild has put together at this link...

http://www.jmwild.com/Accesssecurity.htm
 
I have design a database and set up the user and group permissions. But once
I delete the .mdw file (not the default one), it will automatically open the
database with default mdw file.

My question is I want to share the database with other user. Each user has
different permissions. They can download the database and the workgroup file
to their local drive. They can open the database only with a permitted
account which stored in workgroup file. (If the mdw file was deleted, the
database can’t open). How can I do that?
Click to expand...

In addition to Rick's comment, you'd also need to provide your endusers a way to open the database with your workgroup
file. This is often done by supplying them with a shortcut which opens Access with the correct workgroup file ... the
Target of that shortcut would be something like this:

"full path to msaccess.exe" "full path to your database" /wrkgrp "full path to the workgroup file"



Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Solved.
Thanks for your advise.

Scott McDaniel said:
In addition to Rick's comment, you'd also need to provide your endusers a way to open the database with your workgroup
file. This is often done by supplying them with a shortcut which opens Access with the correct workgroup file ... the
Target of that shortcut would be something like this:

"full path to msaccess.exe" "full path to your database" /wrkgrp "full path to the workgroup file"



Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
Click to expand...
 
Back
Top