Re: Which Workgroup Am I In?
From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 01/11/05
- Next message: Fred Boer: "Re: Which Workgroup Am I In?"
- Previous message: johnceef: "Re: Crystal Reporting on Access database"
- In reply to: Roger Tregelles: "Which Workgroup Am I In?"
- Next in thread: Fred Boer: "Re: Which Workgroup Am I In?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 Jan 2005 09:52:42 -0800
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.)
"Roger Tregelles" <Roger Tregelles@discussions.microsoft.com> wrote in
message news:EF66484B-E4AF-43B9-BC39-C5ED457CCD1A@microsoft.com...
> 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.
>
- Next message: Fred Boer: "Re: Which Workgroup Am I In?"
- Previous message: johnceef: "Re: Crystal Reporting on Access database"
- In reply to: Roger Tregelles: "Which Workgroup Am I In?"
- Next in thread: Fred Boer: "Re: Which Workgroup Am I In?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
