Re: Workgroup information file problem
- From: "Chris O'C via AccessMonster.com" <u29189@uwe>
- Date: Mon, 08 Sep 2008 22:52:07 GMT
You should be permanently joined to the system.mdw file so you don't have to
supply a user name and password every time you open an Access db. If you use
the workgroup administrator to check which workgroup you're joined to, that
only shows which workgroup you're *permanently" joined to, not the one being
used for the current session (which you indicated in your shortcut).
To check which workgroup is being used for the current session push ctrl+g to
open the immediate window. Paste this and push enter:
? syscmd(acSysCmdGetWorkgroupFile)
If you opened the db with your shortcut the path shown will be "\\...network
path to…\Eqpt_Cal.mdw"
If you used the Access 2K security wizard to secure the db, it's probably not
secured. That wizard has a bug. You need to do additional things to make it
secure, like remove permissions from the users group.
It's not clear what you did to "bypass the startup". Did you hold down the
shift key while double clicking on the file name instead of the shortcut?
That will open the db while joined to the permanent workgroup. Or did you
hold the shift key while double clicking on the shortcut? That will open the
db while joining you to the workgroup listed in the shortcut for the current
session.
Chris
Microsoft MVP
CB wrote:
Hi all,
I am confused!!!!! Something came up when I was installing the front end and
short-cut on a computer in our lab.
I have a split database that employs USL. FWIW, the user “Admin” only
belongs to the Users group and that group (and user) has zero permissions,
i.e., that user can’t even open the database. I “own” the database and every
object in it. I am the only user in the Admins group.
Additionally, I’ve removed virtually all access to the menus in MS-Access
(though I haven’t yet disabled the ability to bypass the shift key). The
shortcut to open the database has the following target.
"C:\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and Settings\All
Users\CalDatabase\Eqpt_Cal2003FE.mde" /Wrkgrp "\\...network path
to…\Eqpt_Cal.mdw"
When I select the short-cut, I’m prompted for my username and password. So
far, so good.
I decided to bypass the startup so I had full access to the menus. Then,
something in the back of my mind prompted me to ensure that I was joined to
the proper workgroup. I was joined to the SYSTEM.MDW workgroup! (I didn’t
catch this on my machine because at some point I set Eqpt_Cal.mdw as the
default workgroup file so all appeared to be going well! I'm not even sure
when I did that. Sheesh...)
Anyway, when I look at the user and group accounts and their respective
permissions, I see all the new users I created and all the permissions I
assigned to the various groups. I thought perhaps there was a VERY slight
chance that I accidently modified the SYSTEM.MDW file so I copied another
SYSTEM.MDW file over from another machine. I see the same thing. What
gives??????? I would have expected that if I were joined to that workgroup, I
would see only the default users and their permissions.
FWIW, my database was originally created in Access 2000 and I recently
converted it to Access 2003. Per the Security FAQ, I should still be able to
use my WIF created in A2000 but would this be causing any issues?
I have more questions but have to call it a day.
Thanks for any and all help!
Chris
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200809/1
.
- Follow-Ups:
- References:
- Workgroup information file problem
- From: CB
- Workgroup information file problem
- Prev by Date: Workgroup information file problem
- Next by Date: Re: Workgroup information file problem
- Previous by thread: Workgroup information file problem
- Next by thread: Re: Workgroup information file problem
- Index(es):
Relevant Pages
|
