Hi Guys,

I have a numbers of db's installed in my pc and each of them has its own Workgroup. Is there any way once I open the db then it will
automatically join me to the corresponding workgroup?

Any help or other idea is highly appreciated...


TIA
George

I understand UserLevel Security and a Workgroup Information File would answer you questions however I
have never been able to get that functionality working...

Kenny

----- Original Message -----
From: George Oro
Sent: Saturday, September 28, 2002 2:07 AM
To: Access
Subject: [access] Workgroup

Hi Guys,

I have a numbers of db's installed in my pc and each of them has its own Workgroup. Is there any way once I open the db then it will
automatically join me to the corresponding workgroup?

Any help or other idea is highly appreciated...


TIA
George


to unsubscribe send a blank email to Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

Probably the easiest way to do it is to have a shortcut to each file to open it, rather than 
opening the file directly - this way you can specify the workgroup to use.

The format for the shortcut is:
{Location of Access} {location of file} /wrkgrp {location of worgroup file}

for example:
"C:\Program Files\Microsoft Office\Office\msaccess.exe" C:\DB1.mdb /wrkgrp C:\DB1.mdw

There are other ways to do it (eg. Changing the default workgroup for Access itself using 
code) but this is the quickest and easiest way to do it.

Steven

Thanks Steven, but where I will put this line?

"C:\Program Files\Microsoft Office\Office\msaccess.exe"\Database\MCS\MCSdbase.mdb/wrkgrp C:\Database\MCSWrkGrpFile.mdw

I tried to put it on the Target Line of my shorcut but it doesn't work.


cheers,
George


-----Original Message-----
From: Steven White [mailto:Steve.White@m...]
Sent: Sunday, September 29, 2002 2:57 AM
To: Access
Subject: [access] Re: Workgroup


Probably the easiest way to do it is to have a shortcut to each file to open it, rather than 
opening the file directly - this way you can specify the workgroup to use.

The format for the shortcut is:
{Location of Access} {location of file} /wrkgrp {location of worgroup file}

for example:
"C:\Program Files\Microsoft Office\Office\msaccess.exe" C:\DB1.mdb /wrkgrp C:\DB1.mdw

There are other ways to do it (eg. Changing the default workgroup for Access itself using 
code) but this is the quickest and easiest way to do it.

Steven

ok - what you want to put in EXACTLY is this:

"C:\Program Files\Microsoft 
Office\Office\msaggess.exe" "C:\Database\MCS\MCSdbase.mdb" /wrkgrp "C:\Dat
abase\MCSWrkGrpFile.mdw"

The quote marks are usually only necessary if there's a space in the path 
(Such as the Program Files bit), but it doesn't hurt to put them in 
anyway.
So it's really a matter of
{quote}LocationOfAccess{quote}{space}{quote}LocationOfDatabase{quote}
{space}/wrkgrp{space}{quote}LocationOfWorkGroup{quote}

You nearly had it there - you just needed to specify the drive for the 
database file, and ad some spaces.

Steven

Thanks man, it's working!!!


Cheers,
George


-----Original Message-----
From: Steven White [mailto:Steve.White@m...]
Sent: Monday, September 30, 2002 12:49 AM
To: Access
Subject: [access] Re: Workgroup


ok - what you want to put in EXACTLY is this:

"C:\Program Files\Microsoft 
Office\Office\msaggess.exe" "C:\Database\MCS\MCSdbase.mdb" /wrkgrp "C:\Dat
abase\MCSWrkGrpFile.mdw"

The quote marks are usually only necessary if there's a space in the path 
(Such as the Program Files bit), but it doesn't hurt to put them in 
anyway.
So it's really a matter of
{quote}LocationOfAccess{quote}{space}{quote}LocationOfDatabase{quote}
{space}/wrkgrp{space}{quote}LocationOfWorkGroup{quote}

You nearly had it there - you just needed to specify the drive for the 
database file, and ad some spaces.

Steven

Hi George,
I see this often and have come up with a 'template' the encapsulates the 
enviroment.  I develop in Access 97, 2000 and XP on every OS from 
Windows 3.1 the 95/98/2000 and XP.  Use of the template method allows a 
common method of control not only the Workgroup but also the Access 
version. 

Ignore the carets'^' - i.e. (delete carets for your use)
For regular windows (>=3D3.1 thru 2000 and XP),
Create a Batch (.bat) file, then shortcut to the batch file.

^@ECHO off
^CLS
^SET A97=3D"K:\Apps\access97\office\msaccess.exe"
^SET APP=3D"P:\Projects\ECS\ECS.mdb"
^SET MDW=3D"W:\Production Database\ISU\DHAINV\ECS.MDW"
^%A97% /wrkgrp%MDW% %APP%

If using Citrix,
Create a Command (.cmd) file with;
^@ECHO off
^CLS
^SET A97=3D"K:\Apps\access97\office\msaccess.exe"
^SET APP=3D"U:\Shortcuts\CMS\CMS.mdb"
^SET MDW=3D"W:\Production Databases\ISU\DHAINV\CMS.MDW"
^START "ACCESS DATABASE LAUNCHER" /B %A97% /wrkgrp%MDW% %APP%

Tom Hamilton
T_Systems, Inc
(xxx) xxx-xxxx

 -----Original Message-----
From: 	George Oro [mailto:george@c...]
Sent:	Friday, September 27, 2002 11:01 PM
To:	Access
Subject:	[access] Workgroup

Hi Guys,

I have a numbers of db's installed in my pc and each of them has its own 
Workgroup. Is there any way once I open the db then it will
automatically join me to the corresponding workgroup?

Any help or other idea is highly appreciated...


TIA
George