Re: secured db still opens with system.mdw

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



deb wrote:
I have followed the directions exactly from the website below and was
able to secure the database.
http://www.jmwild.com/security02.htm

However, it reccommends after db is secure, to open Access and
re-join the system.mdw. I did this and now...
When I use the shortcut, the security works great but when I click on
the .mdb the database opens without security.

What did I do wrong??

You missed a step.

Whenever you open a file with a workgroup that does not prompt you for a
user name and password then you are silently logged in as user 'Admin'
member of group 'Users'. In a properly secured file neither of those
entities should be able to open the file.

If you believe you have removed all permissions from 'Admin' and 'Users'
then check the owner of the database. If you left 'Admin' as owner then
that is the problem. Owners have rights above and beyond their permission
settings.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.



Relevant Pages

  • Re: security wizard cannot be run
    ... You need to open your database using your secured mdw (i.e. the desktop ... Open Access (not via the shortcut). ... Create a new mdb and import everything from your 'secure' mdb. ... Once the database opens, the ...
    (microsoft.public.access.security)
  • RE: security wizard cannot be run
    ... secure mdb while joined to system.mdw. ... database is very secure) ... Open Access (no mdb). ... Once the database opens, the ...
    (microsoft.public.access.security)
  • Re: Securing the Front End database
    ... I changed the target of the shortcut to the string that you told me. ... when I click on the FE in Windows Explorer, it opens. ... When you need to make changes to this secure mdb, ... Database Security.mdw that I created? ...
    (microsoft.public.access.security)
  • Re: multiple mdws
    ... > Yes, secure your database. ... > just goingin to Security and adding some groups and changing their access. ... search for a database and the full version opens the secured ...
    (microsoft.public.access.security)
  • Re: multiple mdws
    ... Yes, secure your database. ... just goingin to Security and adding some groups and changing their access. ... search for a database and the full version opens the secured ...
    (microsoft.public.access.security)