Shortcut to workgroup file ignored

[Fred Boer]

Hello!

Well, I am finally tackling Access security. I have read the FAQ a few
times, read the 10 Steps Summarized a few times, and read Jack MacDonald's
paper many dozens of times: at work, at home, in the car, in the washroom,
in bed before going to sleep.. (Which caused my wife to roll her eyes and
give me a disgusted look!). I've gotten good help from good ol' Jeff Conrad,
but I'm struggling, and thought I would spread the work around... <g>

Current problem:

I am working on the section "Use a shortcut to use the correct workgroup the
easy way." I have created a shortcut as directed, but the workgroup file
specified in the shortcut is being ignored. Here's the exact shortcut (using
Access XP, Windows XP):

"C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE" "C:\Documents
and Settings\boerfr\Desktop\Secured WRMS Circulation and Maintenance.mdb"
/wrkgrp "\\wrmsfs1\lib2000$\wrms1.mdw"

I have confirmed the existance of the workgroup file in the appropriate
folder. When I use the shortcut, and go to Tools>Security>Workgroup
Administrator.. , it displays the following workgroup: C:\Documents and
Settings\boerfr\Application Data\Microsoft\Access\System.mdw

Thanks!
Fred Boer

 

[Fred Boer]

Aw, shoot. Never mind. I just remembered about "dbengine.systemdb". When I
tried it, it showed I *was* using the correct workgroup file.

Of COURSE I didn't think of that until AFTER I posted...

Sorry for wasting your time!

Fred

P.S. Yes, Jeff, I know.. you *did* tell me about dbengine.systemdb.. and
yes.. I see that it *is* in Mr. Macdonald's document. Mea culpa!

 

[Joan Wild]

Aw, shoot. Never mind. I just remembered about "dbengine.systemdb".
When I tried it, it showed I *was* using the correct workgroup file.

Of COURSE I didn't think of that until AFTER I posted...

Sorry for wasting your time!

Fred

Just to explain, what is shown in the workgroup administrator is your
default workgroup, not necessarily the one in use.

 

[Fred Boer]

Thanks, Joan!

Fred

Just to explain, what is shown in the workgroup administrator is your
default workgroup, not necessarily the one in use.

 

[Jeff Conrad]

Well, well, well it's about time you showed yourself in this neck of the Access woods.

 

[Fred Boer]

It's a scary part of the forest, and it's easy to get lost in here, but the
park rangers have been helpful!

Fred

 

[Jeff Conrad]

I've been told I'm smarter than the average bear.
Hey Boo-Boo!
<g>

 

[Joan Wild]

It's a scary part of the forest, and it's easy to get lost in here,
but the park rangers have been helpful!

Just stick to the trails, and you'll be fine. ;-)

 

[T. W.]

Fred,
Can you post the links to those papers you read?

Thank beforehand.

 

[Jeff Conrad]

Hi,

Fred is busy trying to keep many students actually interested in what he is talking about at the
moment. So as his teacher's assistant, I'll field the question for him until he has a moment of
peace and quiet.

I believe these are the links Fred was referring to:

Access User-Level Security:

Security FAQ (the Security Bible):
http://support.microsoft.com/?kbid=207793

Jack Macdonald's Security Document:
http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf

Lynn Trapp's Ten Security Steps:
http://www.ltcomputerdesigns.com/Security.htm

Joan Wild's Tips:
http://www.jmwild.com/security02.htm

The Security Whitepaper is also worth reading:
http://support.microsoft.com/?id=148555

 

[Rick Brandt]

Tools>Security>Workgroup Administrator

shows you your default workgroup file, not the one currently being used.
Your shortcut is probably working fine. To confirm execute the following
code after opening your file...

msgbox syscmd(acSysCmdGetWorkgroupFile)