One developer, many users with same permissions

[Mark Page]

Hi,

I received some help earlier in July about securing my DB.
In it I was advised (by Joan Wild) that there is a way to
simply have me as the developer, and all others with the
same permissions. This is because the DB will be on stand
alone PC's.

She suggested that I post back to get help with this.

I've now decided that this method seems to be the most
attractive to my particular circumstances, so I would
appreciate it if someone (or Joan) can let me know what it
is.

Thanks.

Mark

 

[Rick Brandt]

Hi,

I received some help earlier in July about securing my DB.
In it I was advised (by Joan Wild) that there is a way to
simply have me as the developer, and all others with the
same permissions. This is because the DB will be on stand
alone PC's.

She suggested that I post back to get help with this.

I've now decided that this method seems to be the most
attractive to my particular circumstances, so I would
appreciate it if someone (or Joan) can let me know what it
is.

AIUI the way to accomplish this its to grant the authority you want normal users to
have to the default group "Users". Then people can open your file without using your
mdw file and without a login prompt, but their permissions are limited to what you
grant the Users group. Developers would still have to use your mdw file and provide
a login to gain higher levels of authority.