Re: Access 97 Security issue Can't make a MDE

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Keith Wilby (keith.wilby_at_AwayWithYerCrap.com)
Date: 12/21/04 

Date: 21 Dec 2004 16:00:16 GMT

"=?Utf-8?B?Umljaw==?=" <Rick@discussions.microsoft.com> wrote:

> I do NOT have Modify Design or Administer
> permissions for the table. Not signed in as the Admin user or as
> myself with Admin rights. I am not able to CHANGE these rights.

This is confusing me a little - are you trying to make admin changes whilst
not logged on as an admin user?

If you are logged on as an admin user and can't make the change then it
might be down to database ownership - AIUI you need to be the owner of the
database object(s) to make the change you describe.

That being the case then the step by step example on my web site may be of
use. BTW, have you read and understood the MS KB article on user-level
security?

Regards,
Keith.
www.keithwilby.com

Relevant Pages

  • Have lost permissions to modify devices
    ... I have created a new admin user to the local machine but when I try to access ... device manager it tells me i don't have admin rights to uninstall or modify? ...
    (microsoft.public.win2000.general)
  • Re: Security without signon
    ... So my situation continues to be that, using RWOP queries, I can achieve what the title of this thread refers to as 'security without signon' only if the owner of the RWOP query is given explicit permissions on the back-end tables rather than inherited permissions by virtue of group membership. ... It is the different experiences of the default Admin user in my scenario that might be the key to understanding what is going on here. ... There are two mdw files at play in my scenario: the one that I created to secure my database (SecureMDW), and the default one that comes with Access. ... SecureMDW contains these default accounts plus the account for my SuperUser and the account for my SuperGroup, and SuperUser is a member of SuperGroup. ...
    (microsoft.public.access.security)
  • Re: would it be wise???
    ... There are some permissions that are necessary by all users, ... The Admin user is only a member of the users group. ... If the user logs in with username and password from the correct ...
    (microsoft.public.access.security)
  • Re: Lost My Permissions
    ... you have reset the password for Admin user. ... which doesn't/shouldn't have any permissions. ... Accounts and click on change password and change the null password to ... our lowest level group that has read and modify data ...
    (microsoft.public.access.security)
  • Re: <Solved> Run-time version of Access bypasses Secured file
    ... the Admin user getting all permissions. ... User-Level Security and made sure to double-and-triple- ... prompt) you see ...
    (microsoft.public.access.security)