> I setup security groups and users for a particular DB, now when I open
> any DB it requires that I login. I did not intend for that, and it
> will be a problem for other users with limited privileges. How can I
> use security for just a single DB rather than all DBs?
>
> Shane

> Hopefully you didn't set these up in your system.mdw workgroup; the first
> step is to create a new workgroup file.
>
> Anyway, the solution is to use the workgroup administrator to rejoin the
> system.mdw as your default.
>
> Access will use this mdw for all sessions of Access (no login).
>
> For your secure mdb, you can rejoin your secure mdw using the administrator
> (tedious), or create a desktop shortcut that points to your secure mdw.
> Using the shortcut will override the default for just that session.  The
> target of the shortcut would have the following in it:
>
> "Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> shanej2***@yahoo.com wrote:
> > I setup security groups and users for a particular DB, now when I open
> > any DB it requires that I login. I did not intend for that, and it
> > will be a problem for other users with limited privileges. How can I
> > use security for just a single DB rather than all DBs?
> >
> > Shane

> What is the /wkgrp? Is that my workgroup or domain? ie "/myworkgroup"
>
> Joan Wild wrote:
> > Hopefully you didn't set these up in your system.mdw workgroup; the first
> > step is to create a new workgroup file.
> >
> > Anyway, the solution is to use the workgroup administrator to rejoin the
> > system.mdw as your default.
> >
> > Access will use this mdw for all sessions of Access (no login).
> >
> > For your secure mdb, you can rejoin your secure mdw using the administrator
> > (tedious), or create a desktop shortcut that points to your secure mdw.
> > Using the shortcut will override the default for just that session.  The
> > target of the shortcut would have the following in it:
> >
> > "Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
> >
> >
> > --
> > Joan Wild
> > Microsoft Access MVP
> >
> > shanej2***@yahoo.com wrote:
> > > I setup security groups and users for a particular DB, now when I open
> > > any DB it requires that I login. I did not intend for that, and it
> > > will be a problem for other users with limited privileges. How can I
> > > use security for just a single DB rather than all DBs?
> > >
> > > Shane

"Joan Wild" wrote:

> Hopefully you didn't set these up in your system.mdw workgroup; the first
> step is to create a new workgroup file.
>
> Anyway, the solution is to use the workgroup administrator to rejoin the
> system.mdw as your default.
>
> Access will use this mdw for all sessions of Access (no login).
>
> For your secure mdb, you can rejoin your secure mdw using the administrator
> (tedious), or create a desktop shortcut that points to your secure mdw.
> Using the shortcut will override the default for just that session.  The
> target of the shortcut would have the following in it:
>
> "Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> shanej2***@yahoo.com wrote:
> > I setup security groups and users for a particular DB, now when I open
> > any DB it requires that I login. I did not intend for that, and it
> > will be a problem for other users with limited privileges. How can I
> > use security for just a single DB rather than all DBs?
> >
> > Shane
>
>
>