Home All Groups Group Topic Archive Search About

Can one user be joined to multiple workgroups at the same time?

Author
3 Aug 2006 4:46 PM
Donna Rae
I have several databases that are secure for which have different workgroups.
And sometimes a user needs to be able to work in more than one of these.  Is
there another way besides unjoining from one database and joining another
everytime?  Thanks!

Author
3 Aug 2006 6:14 PM
Rick Brandt
Donna Rae wrote:
> I have several databases that are secure for which have different
> workgroups. And sometimes a user needs to be able to work in more
> than one of these.  Is there another way besides unjoining from one
> database and joining another everytime?  Thanks!

"Joining" a workgroup just means "make this one my default" so no, you cannot
have more than one default.

What you can do though is use a workgroup without joining it.  You just specify
it as a command line argument when opening Access.  This is usually done by
creating a shortcut with a target line like...

"Full Path to MSAccess.exe" /wrkgrp "full path to MDW" "Full Path to MDB"

(specifying the MDB to open is optional)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com
Author
5 Aug 2006 12:32 AM
Joan Wild
You might consider securing these databases using the same workgroup file.

--
Joan Wild
Microsoft Access MVP

Donna Rae wrote:
Show quoteHide quote
> I have several databases that are secure for which have different
> workgroups. And sometimes a user needs to be able to work in more
> than one of these.  Is there another way besides unjoining from one
> database and joining another everytime?  Thanks!