By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,054 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Automatically join MDW

P: n/a
Hi all,
There are several MDB's at work which different people have created
using their own workgroups. It is a real pain (albeit not a major issue) to
keep joining the different workgroups each time we use them. Is there a way
to get access to join the necessary workgroup when each DB is opened?

Cheers for your help,

Mark
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Put a shortcut on the desktop for each, and use the /WRKGRP argument in the
command line. You can't code it in the application because the workgroup
must be accessed to open Access itself.

Larry Linson
Microsoft Access MVP

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:ar***************@newsfe5-gui.server.ntli.net...
Hi all,
There are several MDB's at work which different people have created
using their own workgroups. It is a real pain (albeit not a major issue) to keep joining the different workgroups each time we use them. Is there a way to get access to join the necessary workgroup when each DB is opened?

Cheers for your help,

Mark

Nov 13 '05 #2

P: n/a
Hi Larry,
I appreciate your help on this but I forgot to mention I have no
experience in command lines. Could you give an example of how this should
read if the database was in C:\database and the workgroup was in
C:\database\workgroups

Thanks for your patience

Mark

"Larry Linson" <bo*****@localhost.not> wrote in message
news:KJ******************@nwrddc01.gnilink.net...
Put a shortcut on the desktop for each, and use the /WRKGRP argument in the command line. You can't code it in the application because the workgroup
must be accessed to open Access itself.

Larry Linson
Microsoft Access MVP

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:ar***************@newsfe5-gui.server.ntli.net...
Hi all,
There are several MDB's at work which different people have created
using their own workgroups. It is a real pain (albeit not a major issue)

to
keep joining the different workgroups each time we use them. Is there a

way
to get access to join the necessary workgroup when each DB is opened?

Cheers for your help,

Mark


Nov 13 '05 #3

P: n/a
Mark Reed wrote:
Hi Larry,
I appreciate your help on this but I forgot to mention I have no
experience in command lines. Could you give an example of how this
should read if the database was in C:\database and the workgroup was
in C:\database\workgroups

Thanks for your patience

Mark
Create a shortcut... right-click properties

Change the target to....

"<full path to access executable>\<full path of your database" /wrkgrp
"<full path to your workgroup file>"
In A2003 you can access the workgroup administrator from inside
Access... does this also mean you can now possibly access it via code??
:)

Bradley

"Larry Linson" <bo*****@localhost.not> wrote in message
news:KJ******************@nwrddc01.gnilink.net...
Put a shortcut on the desktop for each, and use the /WRKGRP argument
in the command line. You can't code it in the application because
the workgroup must be accessed to open Access itself.

Larry Linson
Microsoft Access MVP

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:ar***************@newsfe5-gui.server.ntli.net...
Hi all,
There are several MDB's at work which different people have
created using their own workgroups. It is a real pain (albeit not a
major issue) to keep joining the different workgroups each time we
use them. Is there a way to get access to join the necessary
workgroup when each DB is opened?

Cheers for your help,

Mark


--
regards,

Bradley
Nov 13 '05 #4

P: n/a
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote...
Create a shortcut... right-click properties

Change the target to....

"<full path to access executable>\<full path of your database" /wrkgrp
"<full path to your workgroup file>"
Actually, you must always have the path to Access itself (msaccess.exe)
first, then a space, then the full path to the database.

In A2003 you can access the workgroup administrator from inside
Access... does this also mean you can now possibly access it via code??
:)


No, the workgroup is chosen before the database is opened.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
Nov 13 '05 #5

P: n/a
Michael (michka) Kaplan [MS] wrote:
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote...
Create a shortcut... right-click properties

Change the target to....

"<full path to access executable>\<full path of your database"
/wrkgrp "<full path to your workgroup file>"


Actually, you must always have the path to Access itself
(msaccess.exe) first, then a space, then the full path to the
database.


Yup, I typed it out wrong:)
In A2003 you can access the workgroup administrator from inside
Access... does this also mean you can now possibly access it via
code?? :)


No, the workgroup is chosen before the database is opened.


Thought as much.
--
regards,

Bradley
Nov 13 '05 #6

P: n/a
Jim
There is an excellent free Access db shortcut builder available from

http://www.headwaysystems.com/

Jim

"Mark Reed" <ma*********@ntlworld.com> wrote in message news:<_0*****************@newsfe6-gui.server.ntli.net>...
Hi Larry,
I appreciate your help on this but I forgot to mention I have no
experience in command lines. Could you give an example of how this should
read if the database was in C:\database and the workgroup was in
C:\database\workgroups

Thanks for your patience

Mark

"Larry Linson" <bo*****@localhost.not> wrote in message
news:KJ******************@nwrddc01.gnilink.net...
Put a shortcut on the desktop for each, and use the /WRKGRP argument in

the
command line. You can't code it in the application because the workgroup
must be accessed to open Access itself.

Larry Linson
Microsoft Access MVP

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:ar***************@newsfe5-gui.server.ntli.net...
Hi all,
There are several MDB's at work which different people have created
using their own workgroups. It is a real pain (albeit not a major issue) to keep joining the different workgroups each time we use them. Is there a way to get access to join the necessary workgroup when each DB is opened?

Cheers for your help,

Mark


Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.