Shortcut to workgroup file ignored

  • Thread starter Thread starter Fred Boer
  • Start date Start date
F

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
 
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! ;)
 
Fred said:
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
Click to expand...

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

Fred

Joan Wild said:
Just to explain, what is shown in the workgroup administrator is your
default workgroup, not necessarily the one in use.
Click to expand...
 
Well, well, well it's about time you showed yourself in this neck of the Access woods.
:-)
 
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
 
Fred said:
It's a scary part of the forest, and it's easy to get lost in here,
but the park rangers have been helpful! ;)
Click to expand...

Just stick to the trails, and you'll be fine. ;-)
 
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
 
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)
 
Back
Top