Access 7

Hello,

Where can I find the workgroup administrator in Access 7.

I don't know why Microsoft had to change around everything in Acc7.
If they want to add features, very good, but why make things complicated for
no good reason.
Thanks

Dnia Mon, 14 Dec 2009 10:53:02 -0500, Abe Katz napisa³(a):

Hello,

Where can I find the workgroup administrator in Access 7.

I don't know why Microsoft had to change around everything in Acc7.
If they want to add features, very good, but why make things complicated for
no good reason.
Thanks

Hi,

Are you talking about Database Tools - Users and Permissions - ... ?
If so, I'm glad I've helped (:

--
Remi.

Are you referring to Access 2007? There is no Workgroup administrator in the
new format, because there is no security. With the MDB format, it's a bit
convoluted. Here's a Knowledge Base article describing how.

http://support.microsoft.com/kb/918583
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Abe Katz" wrote in message
...
Hello,

Where can I find the workgroup administrator in Access 7.

I don't know why Microsoft had to change around everything in Acc7.
If they want to add features, very good, but why make things complicated
for no good reason.
Thanks

"Arvin Meyer [MVP]" wrote in
:

Are you referring to Access 2007? There is no Workgroup
administrator in the new format, because there is no security.
With the MDB format, it's a bit convoluted. Here's a Knowledge
Base article describing how.

http://support.microsoft.com/kb/918583

On first reading I found the wording of your answer confusing,
Arvin, though now on re-reading, I find that it's correct. Put
another way, what you said is:

1. for ACCDB, there is no workgroup administrator because ACCDB
format does not support Jet user-level security.

2. for MDB, the workgroup administrator is not as easily accessible
as it was in the previous version of Access (2003), where it was a
choice on one of the menus (I don't have A2002 installed on this
machine, so I can't tell whether that was added in A2002 or A2003).
The cited article gives instructions on how to launch it from within
Access.

Adding to what Arvin said, though, you might want to just search for
the workgroup administrator executable on your hard drive and create
a shortcut on your desktop (or in your Programs menu). This would
return you to the situation that pertained before the addition of
that menu choice on the Tools|Security menu.

But you should also consider whether you really want to muck around
with this instead of just specifying the workgroup in the shortcut
with which you launch your app.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

"David W. Fenton" wrote in message
36.100...

But you should also consider whether you really want to muck around
with this instead of just specifying the workgroup in the shortcut
with which you launch your app.

If using a shortcut, a sample might be:

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\Database\File.mdb" /wrkgrp "C:\WindowsSystem32\Secure.MDW"

Notice the /wrkgrp switch as the last section.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Dnia Mon, 14 Dec 2009 20:47:55 -0500, Arvin Meyer [MVP] napisa³(a):

"David W. Fenton" wrote in message
36.100...

But you should also consider whether you really want to muck around
with this instead of just specifying the workgroup in the shortcut
with which you launch your app.

If using a shortcut, a sample might be:

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\Database\File.mdb" /wrkgrp "C:\WindowsSystem32\Secure.MDW"

Notice the /wrkgrp switch as the last section.

You can also alter registry key
"HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\ Access\Access
Connectivity Engine\Engines" setting "SystemDB" to REGSZ
"C:\Windows\System32\Secure.MDW"
--
Best regards,
Remi Pi

"Remi Pi" wrote in message
...
Dnia Mon, 14 Dec 2009 20:47:55 -0500, Arvin Meyer [MVP] napisa³(a):

"David W. Fenton" wrote in message
36.100...

But you should also consider whether you really want to muck around
with this instead of just specifying the workgroup in the shortcut
with which you launch your app.

If using a shortcut, a sample might be:

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\Database\File.mdb" /wrkgrp "C:\WindowsSystem32\Secure.MDW"

Notice the /wrkgrp switch as the last section.

You can also alter registry key
"HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\ Access\Access
Connectivity Engine\Engines" setting "SystemDB" to REGSZ
"C:\Windows\System32\Secure.MDW"

That's true, but it becomes the workgroup for all applications, not just 1.
Every time one needs to change workgroup, they would have to dink with the
registry. Finding the wrkgadm.exe file (workgroup administer) and joining a
workgroup is much easier. Even easier still is David's suggestion to use a
shortcut.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Arvin Meyer [MVP]" wrote in
:

"Remi Pi" wrote in message
...
Dnia Mon, 14 Dec 2009 20:47:55 -0500, Arvin Meyer [MVP]
napisa³(a):

"David W. Fenton" wrote in
message
36.100...

But you should also consider whether you really want to muck
around with this instead of just specifying the workgroup in
the shortcut with which you launch your app.

If using a shortcut, a sample might be:

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\Database\File.mdb" /wrkgrp "C:\WindowsSystem32\Secure.MDW"

Notice the /wrkgrp switch as the last section.

You can also alter registry key
"HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\ Access\Access
Connectivity Engine\Engines" setting "SystemDB" to REGSZ
"C:\Windows\System32\Secure.MDW"

That's true, but it becomes the workgroup for all applications,
not just 1.

But so does using the Workgroup Administrator, so it's equivalent to
the original scenario.

Every time one needs to change workgroup, they would have to dink
with the registry. Finding the wrkgadm.exe file (workgroup
administer) and joining a workgroup is much easier. Even easier
still is David's suggestion to use a shortcut.

I was assuming the registry change would be done in code with a UI
provided by the programmer and all that.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/