Re: Location of Workgroup administrator in Office 2002

1 Is your network drive mapped to M:?
2 As Joan said, you should not be able to open the file with system.mdw.

"gdonald20" wrote:

> Hi
>
> Thanks for your reply i have posted the shortcut string below but i am more
> inclined to think it is a network problem. I have the same shortcut to test
> the databse on my C drive the only difference being the "M" in the shortcut
> string are "C".
>
> This shortcut works perfectly and open the database with the security.
>
> "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "M:\OSC Purchase
> Orders\Purchase_Orders.mdb" /wrkgrp "M:\OSC Purchase
> Orders\Purchase_Orders.mdw
>
> Thanks for your help
>
>
>
> "Joan Wild" wrote:
>
> > Starting with 2002, the workgroup administrator is no longer a separate
> > program; it's part of Access - Tools, Security menu.
> >
> > Your best bet is to get the shortcut working. Post the target and someone
> > may see the flaw (remember that if there are spaces in the path, you must
> > enclose it in double-quotes).
> >
> > You say that you are able to browse to the network folder and open it, with
> > no login prompt. That means that it isn't secured properly. If done
> > properly, you shouldn't be able to even open it while using the system.mdw
> > workgroup file.
> >
> > You missed a step in securing it.
> >
> >
> > --
> > Joan Wild
> > Microsoft Access MVP
> >
> > gdonald20 wrote:
> > > Hi
> > >
> > > I having a really strange problem with my access 2002 databse. I have
> > > put it on the network as it needs to be used by many users. I have a
> > > workgroup and a shortcut which is coded to open the database and the
> > > workgroup.
> > >
> > > When i click on the shortcut i get an error message saying it can't
> > > find the database i have checked all spelling etc.
> > >
> > > The strange thing is if i browse to the network folder and double
> > > click on the database itself it opens fine but without the security.
> > >
> > > I can't find the workgroup administrator tool to join the workgroup
> > > therefore taking the need for the shortcut away.
> > >
> > > I thought the workgroup administrator file would have been in
> > > c\programs\microsoft office\office10\1033 but it doesn't appear to be
> > > there.
> > >
> > > Can anyone help
> > >
> > > Thanks
> >
> >
> >
.

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)
  • Forms vs Pages
    ... launch the shortcut it opens the full blown Access App. ... server) or would I need a web server set up with hooks to ... My DB resides on my Network. ... Now when my users click on the shortcut they get an error ...
    (microsoft.public.access.forms)
  • 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: Access2000 Security in Network environment
    ... Place your secure .mdw file on the network somewhere and either have each ... shortcut to launch your secure database and have that shortcut point to the ... appropriate workgroup information file. ...
    (microsoft.public.access.security)
  • Re: Setting up security level
    ... >The others need to join the workgroup where your security ... I have created a database that resides on the network ... >a file from somebody elses computer it opens just fine ...
    (microsoft.public.access.security)