Re: MS Access 97 Security questions

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



<jliebman@xxxxxxxxxxxxxxx> wrote in message
news:1176990582.204356.33550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Joan,

Perhaps I didnt clearly state the problem - users all over the
building are using the application in question - its just that it
cannot be maintained or modified except on the creator's PC using the
creator's userid and password - does that sound like an MDW file
problem, or is it the result of the database objects ownership
settings, or something else entirely?

It sounds like the developer secured it so that the Users Group has some
limited permissions (enough to use it, but not change design). This would
allow the users to use the mdb without needing to login - they are using
their standard system.mdw and being silently logged in as 'Admin', which is
a member of the Users Group and so gets those permissions.

When you need to actually make design changes, you need to login using the
secure mdw on the developer's computer; using that mdw and logging in as a
user that is a member of the Admins Group, allows you to make the changes.
You'd then assign the necessary permissions to the Users Group and deploy.
The users in this case don't need to use the secure mdw.

--
Joan Wild
Microsoft Access MVP


.



Relevant Pages

  • ASP 0177:800401F3 error on COM object instance creation
    ... That works perfect if IUSR_is a member of Administrators group, ... Users group has Modify ... permissions over Web Project directory ... registry permissions. ...
    (microsoft.public.inetserver.iis.security)
  • Cant logon to the remote computer but it seems like has the permissions
    ... Server User Access permissions on this computer. ... members of the Remote Desktop Users group have these ... If you are not a member of the Remote Desktop ... I also added the user in my Remote Desktop Users. ...
    (microsoft.public.windows.terminal_services)
  • Re: User rights for Power Management
    ... I had to set the permissions one level higher. ... > | I have also tried making these users a member of the Power ... > | Users group on the laptop, but that hasnt made any difference. ... > For information on how to assign permissions to a registry key ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: table pesmissions
    ... That table was created while you were joined by default to some secure mdw. ... You need to open your database using that mdw and then assign permissions to ... the Users Group for the table. ...
    (microsoft.public.access.security)
  • Re: XP Pro file permissions
    ... > logged-in Administrator automatically becomes member of Users group. ... > expanded to permissions of a regular User. ...
    (microsoft.public.windowsxp.security_admin)