How do i join a workgroup in access 2007

Discussion in 'Information Technology' started by Parsifal, Jul 28, 2006.


  1. Parsifal

    Parsifal Guest

    Hi there,

    I've just downloaded and installed new access 2007. I wanted to play
    with one of my database wich is restricted by a workgroup but i can't
    open it because i can't join the workgroup file (i can't find it in the
    menus like in my access 2003).
    I've tried to pass the /wrkgrp option in the options menu -> command
    line argument in advanced section but it doesn't work)

    Please help me :) i'm going nuts !
     
  2. Parsifal

    Parsifal Guest

    Parsifal a écrit :
    > Hi there,
    >
    > I've just downloaded and installed new access 2007. I wanted to play
    > with one of my database wich is restricted by a workgroup but i can't
    > open it because i can't join the workgroup file (i can't find it in the
    > menus like in my access 2003).
    > I've tried to pass the /wrkgrp option in the options menu -> command
    > line argument in advanced section but it doesn't work)
    >
    > Please help me :) i'm going nuts !

    ok i've found a workaround.
    I've created a link to access 2007 then added the /Wrkgrp switch with my
    filename to the command line so that access use it a its workgroup, i
    then have been able to open my workgroup protected database without
    problems :)

    Anyway, if someone knows how to join a workgroup from within access i
    still want to know how...
     
  3. As I understand it, there is currently no menu command to do this. You can
    do it programmatically like so ...

    DoCmd.RunCommand acCmdWorkgroupAdministrator

    JET ULS (User-Level-Security) is being deprecated in Access 2007. It is
    supported for backwards-compatibility if you use Access 2000 or Access
    2002/2003 file format, but is no longer supported if you use the new Access
    2007 file format.

    --
    Brendan Reynolds
    Access MVP

    "Parsifal" <parsifal_fey_oj@msn.com> wrote in message
    news:O6ZObvKgGHA.4976@TK2MSFTNGP02.phx.gbl...
    Parsifal a écrit :
    > Hi there,
    >
    > I've just downloaded and installed new access 2007. I wanted to play with
    > one of my database wich is restricted by a workgroup but i can't open it
    > because i can't join the workgroup file (i can't find it in the menus like
    > in my access 2003).
    > I've tried to pass the /wrkgrp option in the options menu -> command line
    > argument in advanced section but it doesn't work)
    >
    > Please help me :) i'm going nuts !

    ok i've found a workaround.
    I've created a link to access 2007 then added the /Wrkgrp switch with my
    filename to the command line so that access use it a its workgroup, i
    then have been able to open my workgroup protected database without
    problems :)

    Anyway, if someone knows how to join a workgroup from within access i
    still want to know how...
     
Loading...