Default mdw

[Al]

Please,
I have setup security on my mdb with the mdw in the same
folder, this was setup as my default mdw in the Security
Wizard and it works fine during the day.
The issues is in the last week, every morning when I come
in to work, Access reverts back to the system.mdw. Any
thoughts why this consistently does this each day? I am
able to go to another Access program and switch back to my
mdw but of course this is cumbersome, I've done something
wrong. How can I permanently change to my mdw without
going thru the security wizard again.

thank you.

 

[Jack MacDonald]

the best way to use a workgroup file is to always default to the
unsecured system.mdw. But make a shortcut that launches your database
with the correct workgroup file. The syntax for the shortcut target
is:

"full path to Access.exe" "full path to MDW" /wrkgrp "full path to
workgroup file"

Please,
I have setup security on my mdb with the mdw in the same
folder, this was setup as my default mdw in the Security
Wizard and it works fine during the day.
The issues is in the last week, every morning when I come
in to work, Access reverts back to the system.mdw. Any
thoughts why this consistently does this each day? I am
able to go to another Access program and switch back to my
mdw but of course this is cumbersome, I've done something
wrong. How can I permanently change to my mdw without
going thru the security wizard again.

thank you.

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Immanuel Sibero]

"full path to Access.exe" "full path to MDW" /wrkgrp "full path to
workgroup file"

should this be: (?)

"full path to Access.exe" "full path to MDB" /wrkgrp "full path to
workgroup file"


Immanuel Sibero

 

[Al]

First of all, which Access version are you using? If you
are using 2000 and up you can change the mdw from within
access. I am assuming that you made a copy from the
system.mdw or created a new mdw using the wizard(workgp
manager). You should not have to make a short cut to assure
that you are not using the sys.mdw. You can rename the
system mdw and move it to another place so that access may
be forced to use the one in the same directory. If you were
using 2002 make sure that the .mdw is in the same format,
i.e. it is not in 2000 format. Try to join from within
access. Let me know if you still having a problem.
Al

 

[Joan Wild]

should this be: (?)

"full path to Access.exe" "full path to MDB" /wrkgrp "full path to
workgroup file"

Doesn't have to be, either will work. The order matters for some of the
switches, but no the wrkgrp switch.

Oops - just re-read that...Jack does have a typo, but
/wrkgrp "workgroup path" "mdb path"
"mdb path" /wrkgrp "workgroup path"
either of these will work.

The only thing that matters is that the path to the mdw follows the /wrkgrp
switch.

 

[Jack MacDonald]

Ooops. typo.

should this be: (?)

"full path to Access.exe" "full path to MDB" /wrkgrp "full path to
workgroup file"


Immanuel Sibero

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security