Re: Identical user names, different DB

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 16:19:28 -0400

Miaplacidus wrote:
> I have a shortcut that reads:
>
> "C:\Program Files\Microsoft Office\Office10
> \MSACCESS.EXE" /wrkgrp "\\Org\Administrative\Office
> \FrontOfficeDB.mdw" "\\Org\Administrative\Office\ECAD.mdb"
>
> When I Click on this file I get a logon screen and I logon
> as normal. But when I inspect the wrkgrp setting using the
> wrkgrp administrator it indicates that I am looged on to
> system.mdw. Why is this? I thought the purpose of the
> shortcut was to direct you to the correct wrkgroup file.

Actually the workgroup administrator does not tell you the current workgroup
file in use. It tells you what your default workgroup file is. To verify
open via your shortcut and hit Ctrl-G and type
?dbengine.SystemDB
That will tell you the mdw in use.

>
> Here is more fun. I'm logged on as Me with Password A.
> I close ECAD.mdb but leave Access open. Now I open another
> database: C:\MyDocs\Test.mdb and it opens right up. Now I
> close test.mdb and exit Access. I go to Mydocs and click
> on the icon for test.mdb and I get a logon screen. If I
> Logon as Me with Password A, then I don't have privileges.

If you are getting a login dialog by opening a mdb directly in My documents,
then your system.mdw (which you are joined to by default you say) has a
password set for the Admin user. User Me with Password A is not in the
system.mdw workgroup.

>
> It happens that Mydocs\Test.mdb has a user named Me but
> with password B.

Databases do not have users, mdw files do.

> If I log on as Me with Password B it
> opens right up. Having logged in as Me with password B I
> can now close Test.DB navigate to ECAD.db and open it
> right up.

Me with password B is in the system.mdw workgroup.
>
> If I change my default wrkgrp to FrontOfficeDB.mdw I can
> still log on to either database as Me, provided that I
> first log on to the "correct" one.

Huh? You are logging in using FrontOfficeDB.mdw. So there is no log into
the 'correct' mdb first.

>
> Does this mean that when my FrontOfficeDB.mdw gets
> corrupted that I can still get in with some other mdw as
> long as I have one with the same username?

If both mdw files contain the same username AND it was created using the
exact same SID. Otherwise the two 'Me' users are different. 

-- 
Joan Wild
Microsoft Access MVP

Relevant Pages

  • 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: Workgroup security files.
    ... If I have an employees DB and a press release DB on my ... I don't understand your message.I'm sure the shortcut ... explorer and the password dialog opens. ... Can I use the wizard to create a second workgroup? ...
    (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)
Loading