Shared Drive

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lgraham - 04 Jan 2008 20:11 GMT

Hi,

I created a security workgroup for a database on a shared drive. I created
it in exclusive mode. Now that I've joined users, I've realized that the
security defaults apply not exclusively to the database that I intended, but
to all of the databases on each individuals computers, or personal drives.
Help!

lgraham

Reply to this Message

Joan Wild - 04 Jan 2008 20:38 GMT

Access always uses a workgroup file (mdw), even for unsecured databases. It sounds like you set their default workgroup to your secure mdw. That is why it is asking for a username/password. The mdw is tied to the session of Access, not to a database.

Rejoin them to the system.mdw that ships with Access, and provide a desktop shortcut for the secure mdb. The shortcut target would have the following in it:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

Signature

Joan Wild
Microsoft Access MVP

> Hi,
>
[quoted text clipped - 5 lines]
>
> lgraham

Reply to this Message

lgraham - 09 Jan 2008 14:38 GMT

Thank you for your help-

> Access always uses a workgroup file (mdw), even for unsecured databases. It sounds like you set their default workgroup to your secure mdw. That is why it is asking for a username/password. The mdw is tied to the session of Access, not to a database.
>
[quoted text clipped - 10 lines]
> >
> > lgraham

Reply to this Message