Which Workgroup Am I In?

[Guest]

Hi Folks,

I've read and re-read all I can about Microsoft Security (especially Jack
MacDonald's guide). I created a new Workgroup File on a network drive for my
department. I then created a shorcut to log me onto this workgroup as follows:

“C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE†/wrkgrp
“Q:\QualityWorkgroup.mdwâ€

When I execute the shortcut it brings me into Access no problem. However,
when I go to Tools>Security>Workgroup Administrator it says I still am logged
onto the default workgroup instead of the new QualityWorkgroup. I've read
postings here showing that this is normal, and that you need to use the
DBEngine.SystemDB command to see which workgroup you are in. My question is,
how do I do this exactly. I don't know a lot about VB but saw a post that
said to do this.

Are you using the following in VBA's immediate window to make sure which
..mdw you're joined to? - ? application.DBEngine.SystemDB

I type "? application.DBEngine.SystemDB" in the Immediate Window in the VB
Editor and then clicked on the Run button and all it does is bring up a
window for Macros which has none listed. What am I doing wrong here? I want
to make sure I'm in the correct workgroup before I start creating User and
Group accounts. I'm using Access 2002 in a Windows XP Professional
environment. Any and all help would be greatly appreciated. Thanks in advance.

Roger Tregelles
Quality Assurance Engineer
Respironics Inc.

 

[Fred Boer]

Dear Roger:


This should work. You don't click on "Run", however, just hit "Enter" after
you've finished typing. The result will appear directly below the line you
just typed.

HTH
Fred Boer

 

['69 Camaro]

Hi, Roger.

In the Immediate window, type:

?DBEngine.SystemDB

and then press the <ENTER> key, and you'll see which workgroup information
file you are joined to.

Hitting the Run button executes the code starting where the cursor is
located in the code window, which is probably located outside of a public
procedure or inside a public procedure that requires parameters to be passed
to it, which you didn't provide. Hence, the "Macros" window displays for
you to select something else to execute.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Guest]

Thanks to both Gunny and Fred for the quick and concise replies. It worked
just as you both mentioned, and my shortcut is working and has me in the
correct workgroup. Now comes the fun of creating the Users, Groups and
securing the database objects. If I get stuck, I'll be back to look for more
expert and helpful advice. Thanks again to both of you.

Roger Tregelles
Quality Assurance Engineer
Respironics Inc.