How do i join a workgroup in access 2007

[Parsifal]

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 !

 

[Parsifal]

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

 

[Brendan Reynolds]

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