Share the database with Security control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lone - 20 Aug 2007 04:40 GMT

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?

Reply to this Message

Rick Brandt - 20 Aug 2007 12:31 GMT

>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

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Scott McDaniel - 20 Aug 2007 13:16 GMT

>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
[quoted text clipped - 5 lines]
>account which stored in workgroup file. (If the mdw file was deleted, the
>database cant 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

Reply to this Message

Lone - 21 Aug 2007 03:28 GMT

Solved.
Thanks for your advise.

> >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
[quoted text clipped - 15 lines]
> scott@takemeout_infotrakker.com
> www.infotrakker.com

Reply to this Message