Re: Shortcut does not join secure workgroup

Tech-Archive recommends: Fix windows errors by optimizing your registry



"Sietske" <Sietske@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:356BAD6C-3B4B-4A00-84D3-E3678216C50C@xxxxxxxxxxxxxxxx
I've made a shortcut from the desktop to join a secure workgroup and start
Access for only one session. However, when checking the current workgroup, I
see that I still joined the standard and insecure system.mdw.

My shortcut looks like this:

"C:\Program Files\Microsoft Office\MSACCESS.EXE" /WRKGRP
G:\Data\Access\SecureGroup.mdw

Did I do something wrong? Or is it correct what I did, and do I see the
standard workgroup because my shortcut only joins the secure workgroup for
one session?

Bingo. The shortcut doesn't change your default workgroup, it just overrides it and uses the target specified one for that session. Tools, Workgroup Administrator will always show you what your default is set to.

If you want to confirm the workgroup currently in use, open via your shortcut, hit Ctrl-G and type the following in the immediate window
?DBEngine.SystemDB

--
Joan Wild
Microsoft Access MVP
.



Relevant Pages

  • Re: Shortcut on desktop
    ... > of the shortcut, ... > which specifies the correct workgroup to use for the session. ... > permission to use your secure mdb. ...
    (microsoft.public.access.security)
  • Re: Location of Workgroup administrator in Office 2002
    ... in the same folder. ... You shouldn't have multiple users sharing the same mdb. ... > shortcut to test the databse on my C drive the only difference being ... >> while using the system.mdw workgroup file. ...
    (microsoft.public.access.security)
  • Re: Identical user names, different DB
    ... > shortcut was to direct you to the correct wrkgroup file. ... Actually the workgroup administrator does not tell you the current workgroup ... mdw files do. ... > opens right up. ...
    (microsoft.public.access.security)
  • Re: Workgroup vs Command Line
    ... The shortcut switch will use the specified workgroup file for that session. ... administrator will still show the default). ... > to invoke the respective security file. ...
    (microsoft.public.access.security)
  • Re: i give up...please tell me how to remove security
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... > When I copied the database over I also copied the "secured.mdw" file and ... > shortcut that I used to open it. ... I changed the workgroup in the target of the shortcut to refer to this ...
    (microsoft.public.access.security)