Shortcut to workgroup file ignored

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
 
F

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! ;)
 
J

Joan Wild

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

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

Fred Boer

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.
 
J

Jeff Conrad

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

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
 
J

Joan Wild

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! ;)

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

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
 
R

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top