Re: distribution and security

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

"sturner333" <sturner333@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:92E900EE-8D0A-4DBF-82AE-E0677B72368B@xxxxxxxxxxxxxxxx
I seem to be able to open the database either from the desktop shortcut with
one mdw and from inside of access with the default mdw. This changes the
permission of the user. How do I make it so the database requires the mdw
from the shortcut?

The you missed a step in applying security. This means you fall into the same
category as 90% of users when attempting security for the first few times. :-)

When applied properly you should not be able to open the file at all unless you
use the correct MDW file. Check to make sure that the default user "Admin" is
not still listed as the owner of the database object. Owners haves rights even
if they don't explicitly have permissions. Otherwise I suggest Googling for the
detailed step by step instructions that are posted in this group frequently and
starting over.


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


.

Relevant Pages

  • Re: User access on a company intranet
    ... All users need full permission on the folder where the mdb is located. ... You wouldn't need to do this in your copy of the database. ... then the only way to open the secure mdb is by using the mdw you ...
    (microsoft.public.access.security)
  • Re: Security not clicking
    ... Did you start with the original unsecured copy of your database? ... Did you compile and compact the mdb before running the wizard? ... Copy the secure mdw to the server. ...
    (microsoft.public.access.security)
  • Re: User access on a company intranet
    ... I did as you said and created a shortcut with the path you gave me and it ... I have built into my database should I disable this? ... When you want to implement security, you create a new mdw file, and follow ... to open the secure mdb is by using the mdw you created. ...
    (microsoft.public.access.security)
  • Re: security wizard cannot be run
    ... OK - I opened the database using the secure mdw using a username and password. ... I granted full permissions to the user group. ...
    (microsoft.public.access.security)
  • Re: User access on a company intranet
    ... any prompt then what I have set up within my database. ... How do I give them permission. ... The path to mdw would be the path to the mdw you used to secure it with. ... database is in a folder only people in my department can access. ...
    (microsoft.public.access.security)