1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Dear Guest, we truly appreciate your patience while we are working hard on the upgrade process, which was forced upon us due to the decline of our original forum software. Good news is SPN is almost ready to resume its normal operations soon. The new cutting edge software has been chosen with a primary focus on enhancing user experience especially while using SPN on the mobile devices such as tablets or phones. This new platform will also provide us the opportunity to implement new ideas which were not possible in old software. Forum appearance will be an on going process and you would notice significant changes as we mature working in the new software environment. Some of the core functionality like the blogs will be restored gradually. Once, the forum is fully active, please take your time navigating around the new forum functionality. We will also introduce you to new functionality from time to time.

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...
     

Share This Page