How to find the workgoroup Administrator

2 Oct 2006 12:24 PM

Saman

Please berif how to find the workgroup administrator from the ribbons. Or
it's available in another location.

I have security database done in access 2000 format through acess 2002-2003.
and I need open that in new access 2007. Hope I should link the security
inorder to open. But I cannot find the workgroup administartor.

Please help

2 Oct 2006 12:36 PM

Brendan Reynolds

Enter the following line in the Immediate Window ...

DoCmd.RunCommand acCmdWorkgroupAdministrator

--
Brendan Reynolds
Access MVP

Show quoteHide quote

"Saman" <Sa***@discussions.microsoft.com> wrote in message
news:25BD0F75-9D60-487E-B760-3C9FE6B2E723@microsoft.com...
> Please berif how to find the workgroup administrator from the ribbons. Or
> it's available in another location.
>
> I have security database done in access 2000 format through acess
> 2002-2003.
> and I need open that in new access 2007. Hope I should link the security
> inorder to open. But I cannot find the workgroup administartor.
>
> Please help

2 Oct 2006 10:11 PM

Joan Wild

Although you can change the default workgroup file, you should consider just
creating a desktop shortcut to launch it. Changing the default will make it
the default for all your databases.

The target of the shortcut would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

--
Joan Wild
Microsoft Access MVP

Saman wrote:

Show quoteHide quote

> Please berif how to find the workgroup administrator from the
> ribbons. Or it's available in another location.
>
> I have security database done in access 2000 format through acess
> 2002-2003. and I need open that in new access 2007. Hope I should
> link the security inorder to open. But I cannot find the workgroup
> administartor.
>
> Please help