Share the database with Security control

[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?

 

[Rick Brandt]

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.

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?

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

 

[Scott McDaniel]

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?

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

 

[Guest]

Solved.
Thanks for your advise.

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