Re: security only works on my PC

Well, then I guess I did something wrong because I was able to open it with
ease through Explorer. I didn't even need a name or password.

Also, I've read a lot on this board about frontends and backends and I'm not
sure how a database would be split or why it should be done at all. My
database is all at one location, in a folder on the network.

"Joan Wild" wrote:

brem219 wrote:
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?

Before you go to each user's PC test that your database is secured properly.
Just open Windows Explorer and double click the 'secure' mdb. You shouldn't
be able to even open it. If you can, then it isn't secured properly.

Once you have it tested, yes you need to provide the shortcut and the
frontend to each user. If you are confident that everyone has a typical
installation of Access, you can just copy the mdb and copy the shortcut
(it's a file with a lnk extension).


"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: 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)
  • Re: Securing Back-End, Using one .mdw file on FE & BE
    ... It sounds as though the Users Group still has Open permission on the Database Object - double check that. ... You open a session of Access using your secure mdw and logging in as the user you want to be owner. ... Remove permissions for every object for the Users Group ... I am using a shortcut to open the FE, I have gone through all appropriate steps to properly secure the DB. ...
    (microsoft.public.access.security)
  • Re: User and Group Permissions
    ... You need to give them access to the secure workgroup file. ... on the network that everyone has access to. ... Modify your shortcut to point ... (I didn't give unregistered users any permissions). ...
    (microsoft.public.access.security)
  • Re: security question
    ... Using Read With Owners Permission queries, ... users all permissions to the raw tables. ... >secure .mdw file and a shortcut to open the db. ...
    (microsoft.public.access.security)
  • Re: Desktop shortcuts dont work
    ... I don't see anything that strikes me from a security perspective. ... Since the permissions on the redirected Desktop folder seem OK, have you run that tool to check the context menu handlers? ... The other diagnostic tool you could try is filemon - start monitoring, try to access the shortcut, and see what it logs when it fails. ... The shortcut has grayed out Full Control given to Administrator and to System. ...
    (microsoft.public.windows.server.sbs)
Loading