mdw file for two sep db's

[Nancy]

I have two db's with linked tables. I want to use the same mdw file for
both. How do I do this without joining the workgroup each time?

 

[A C]

I have two db's with linked tables. I want to use the same mdw file for
both. How do I do this without joining the workgroup each time?

I am total novice-newbie in this area, but in our testing/learning we open
our databases using a shortcut which explicitly list the workgroup to use.
For example:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\mypath\myDbase.mdb" /wrkgrp "C:\myMDWPath\myMDW.mdw"

This should automatically join you to your mdw when you open the dbase. So
if can use shortcuts to open your database then this should save you having
to rejoin each time.

Hope this is what you were after.
A

 

[TC]

You're right, with one small quibble!

Using the shortcut doesn't really "join" you to that workgroup file.
Most people reserve the term "join", for what happens when you use the
workgroup administrator program or function to select a workgroup. That
selection sticks until you use the workgroup administrator program or
function to change the selection again.

The shortcut, as you know, just causes Access to use the specified
workgroup file, for that run only, without actually "joining" it in the
sense described above.

To the original poster: you have a slight misunderstanding about
workgroup files. When you start Access, it selects a workgroup file. It
then uses that workgroup file for every database that you subsequently
open in that copy of Access. It does not say "Ooo, he's linking to a
different database, I'll use a different workgroup file for that one".

That is, the workgroup file applies to that session of Access - not to
any particular database that you open with that session of Access.

HTH,
TC