Re: security only works on my PC

OK, thank you. I rejoined the system.mdw workgroup and set up the shortcut
successfully on my PC. I had already removed permissions from the users
group and replaced them with RWOP queries so no problem there.

Now I want to do the same thing on my co-workers' PCs. Do I have to go to
each of their PCs and link to system.mdw and create the shortcut just like
you showed me?

"Joan Wild" wrote:

brem219 wrote:

You need to use the
workgroup administrator to rejoin the system.mdw workgroup file that
ships with Access.

I don't know what this means. I opened the workgroup administrator
but only saw the new workgroup I created when I added security. If
there's another one, where do I find it?

It depends on version, but it usually is in the windows system folder. Use
Start, Search, and look for *.mdw on your hard drive. Be sure you include
system and hidden folders in the search, and make a note of the path(s) it
finds. You are looking for system.mdw. When you open the Workgroup
Administrator, click on Join and rejoin the system.mdw. You should now get
no login when opening a mdb.

Then use a desktop shortcut to launch your secure mdb The
target would be
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

I don't know how to do a shortcut. Do I just right click on my
desktop and type in exactly what you wrote?

Right-click the desktop and choose New...shortcut. Click on browse and
locate msaccess.exe (it'll be something like c:\Program Files\Microsoft
Office\Office11\) and finish. Go to the desktop and right-click this
shortcut and choose properties. It'll open to the shortcut tab, and you'll
see the target line with the path to msaccess.exe. Just edit that and add
the path to mdb, the switch, and path to secure mdw.

I want my the 6 users to be able to open the database. The database
is configured so that users will be able to access the tables through
a series of queries, but not look at or change the tables. I'm not
sure about changing the permissions. I've adjusted the permissions
on my PC so that 2 of the 6 users have admin priveleges, and the
ability to look at tables and change the database.

Normally, you would not assign any permissions to the Users Group when
securing a database. The exception would be if you want security, but don't
want users to have to login. If you assign permissions to the Users Group,
then they don't need your secure mdw. They can use the standard system.mdw
on their system, and not log in.

It is possible to remove all permissions on the tables, and then use run
with owner permission (RWOP) queries for all data interaction. However,
usually you'd provide a form for users to use, rather than just a query.

--
Joan Wild
Microsoft Access MVP



.

Relevant Pages

  • Re: Workgroup information file problem
    ... the workgroup administrator to check which workgroup you're joined to, ... used for the current session (which you indicated in your shortcut). ... like remove permissions from the users group. ... That will open the db while joined to the permanent workgroup. ...
    (microsoft.public.access.security)
  • Re: security only works on my PC
    ... workgroup administrator to rejoin the system.mdw workgroup file that ... I opened the workgroup administrator ... click on Join and rejoin the system.mdw. ... sure about changing the permissions. ...
    (microsoft.public.access.security)
  • Re: Workgroup information file problem
    ... the workgroup administrator to check which workgroup you're joined to, ... used for the current session (which you indicated in your shortcut). ... database pretty much like the one I already created for company one. ... lot of playing around with the various permissions on various objects. ...
    (microsoft.public.access.security)
  • Re: Old Question, new twist: No read definitions
    ... I am unable to change any permissions at all, ... > Workgroup ID: JCInc ... Given what I see in the above, the 'original WIF' doesn't exist anymore ... If you don't have a shortcut, then create one with the above in the target. ...
    (microsoft.public.access.security)
  • Re: security only works on my PC
    ... shortcut successfully on my PC. ... Just open Windows Explorer and double click the 'secure' mdb. ... I opened the workgroup administrator ... I'm not sure about changing the permissions. ...
    (microsoft.public.access.security)