Re: Secure shortcut Unsecure File

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I own every object. The users group has permission to open/run in the
Database object type. Should this be unchecked?

What do you mean when you say 'open the main mdb'?

I mean by not using the shortcut


"Joan Wild" wrote:

That particular step wouldn't cause your problem.

As I understand you, you have a shortcut with the following in the target:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"



As for the security, it is impossible for me to know what step you
overlooked. Can you verify (via the Tools, Security, permissions dialog)
what user owns every object, and also verify that the Users Group does not
have permission to anything.

--
Joan Wild
Microsoft Access MVP
"Matt W." <MattW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F43872E5-B22F-42DB-B047-0CA6CCBBB09C@xxxxxxxxxxxxxxxx
Joan,
I followed your instructions
http://www.jmwild.com/security02.htm

I did steps 1-15, then 22-32. Step 21 says it is recommended to choose
"i
want to create a shortcut to open my secured database" Your instructions
had
me skip this step as i started with step 1. Do you think this is where my
problem lies? If so, is there a way i can modify this mdw or do i need to
create a new one and should i start with step 16?

Thanks for your help.

"Joan Wild" wrote:

"Matt W." <MattW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:78D11D23-36D7-44B6-B776-203935CAEE31@xxxxxxxxxxxxxxxx
When opening the shortcut, security works fine. When opening the main
.mdb
it
opens without security.

If that's the case, then you missed a step in securing it. They
shouldn't
be able to even open the mdb unless they use the right mdw file.

Well if people learn the path won't they be able to
open the original file and see everything? If I have the original .mdb
put
in
a network folder that is inaccessible to them, will they be able to
view
the
information in the database via shortcut?

All users need modify permission on the folder where the mdb is located.


--
Joan Wild
Microsoft Access MVP






.

Relevant Pages

  • Re: user level security wizard
    ... When I click on the shortcut on the desktop, the error message box shows the ... the name of the database in this shortcut was not the copy, ... you said that every mdw file has the admin user and the Users Group ... where in the wizard do you tell it who the users are, ...
    (microsoft.public.access.security)
  • Re: security only works on my PC
    ... still able to enter Explorer and enter the database without a login. ... checked the permissions box and the Users group has no permissions on ... Open it using your shortcut and log in. ... Click on the Groups option and select the Users Group. ...
    (microsoft.public.access.security)
  • Re: User Level Security allowing External Queries
    ... In order for it to work,you can give the Users Group open permission on the ... database object, and read data permissions on the table. ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)
  • Re: security only works on my PC
    ... I checked the permissions box and the Users group has no ... Open/Run and open exclusive on database object ... Open it using your shortcut and log in. ... Click on the Groups option and select the Users Group. ...
    (microsoft.public.access.security)
  • Re: Join a Workgroup
    ... shortcut in order to open your secure database. ... the Users Group, you can't change that. ... I now am try to split my database by using the instructions you provided ...
    (microsoft.public.access.security)