Re: Workgroup security files.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: miaplacidus (mia_placidus_at_hotmail.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 05:44:20 -0700

I don't think that was the answer to my question.

1). If I have an employees DB and a press release DB on my
computer, then I apply security to the employees DB; why
does that affect the press release DB?

2). I don't understand your message.I'm sure the shortcut
is there, but it's transparent to me. I click on the DB in
explorer and the password dialog opens. Under what
circumstances would I need to use the (commandline?)
statements you quoted?

3). Why do I need to open access and the DB on onecommand
line? If I open the DB doesn't that intantiate Access?

4). How is FullPathToSecure different from FullPathToDB if
the DB is secure?

5). What does the flag /wrkgrp do if the shortcut is
already operational?

6). Suppose I wanted different users and a different
usergroup for differnt DB's on the same machine. Is that
what the shortcut FullPathToDB /wrkgrp is supposed to?
That is direct that DB to its own workgroup?

7). Can I use the wizard to create a second workgroup?

>-----Original Message-----
>No, the workgroup that you are joined to is specific to
each computer. If
>you used the wizard to do your security, then it created
a shortcut on your
>desktop. If you did it manually, then you need to create
that shortcut
>manually. You need to join the system.mdw file that
shipped with Access and
>then use the shortcut to open your secure databases. The
syntax for the
>shortcut target is:
>
>"FullPathToMSAccess.exe" "FullPathToDatabase.mdb" /wrkgrp
>"FullPathToSecure.mdw"
>
>--
>Lynn Trapp
>MS Access MVP
>www.ltcomputerdesigns.com
>Access Security: www.ltcomputerdesigns.com/Security.htm
>
>
>"miaplacidus" <Mia_placidus@hotmail.com> wrote in message
>news:0d0a01c46e97$6461bae0$a601280a@phx.gbl...
>> I'm a newbie at Access scurity. I created a copy of a
>> database and worked the the steps in the FAQ on how to
>> protect your dataase, created a workgroup file etc.
>> Everything worked fine.
>>
>> Now all of my databases request a password on opening
and
>> they all have the same users etc as the one I was
playing
>> with. This includes DB's on the network drive and my
local
>> drive. What gives?
>>
>> Isn't a workgroup file DB specific?
>
>
>.
>

Relevant Pages

  • 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: Location of Workgroup administrator in Office 2002
    ... Is your network drive mapped to M:? ... I have the same shortcut to test ... the workgroup administrator is no longer a separate ... >>> click on the database itself it opens fine but without the security. ...
    (microsoft.public.access.security)
  • Re: Location of Workgroup administrator in Office 2002
    ... Thanks for your reply i have posted the shortcut string below but i am more ... inclined to think it is a network problem. ... the workgroup administrator is no longer a separate ... >> click on the database itself it opens fine but without the security. ...
    (microsoft.public.access.security)
  • Newbie security questions
    ... When Access opens it picks up the username and password ... from the workgroup file. ... Then when the mdb file opens it ... that I have to go to each user and put the shortcut on ...
    (microsoft.public.access.security)
  • Re: mailto: shortcut opens up Outlook Express, not new message
    ... Workaround: If nothing helps, try this shortcut: ... When I right-click on the new New Mail Out icon and select 'Properties', ... Internet Shortcut which opens with Outlook Express. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)