Re: Probs accessing database for users of newly developed Superuser gr

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

I'm working offline, so can't go to your link, but what does the message
say? i.e. what is in the <...> part - the database, a table/query/form?

--
Joan Wild
Microsoft Access MVP
"CB" <CB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB773C6C-D244-486B-9F2A-CF27DE9CE468@xxxxxxxxxxxxxxxx
Hi everyone,

I have a split database (Access 2003) that employs USL. Users access the
database from a shortcut on their desktop. I have been having problems
when
logged in as a Full-data user that I have not been able to resolve (see
posting here: http://tinyurl.com/3ljnx3). As a result, I decided to use
the
Security feature (Tools/Security…) to create a new group called Superuser.
This group is to have virtually all permissions except administer. I then
assigned two users to the group.

When I try to log in as one of those two users (using the same shortcut I
used to change the permissions!), I get the error message “You do not have
necessary permissions to use <….> object. Have your system administrator
or
the person who created the object establish appropriate permissions for
you.”

What gives???? I’m really pulling my hair out between this issue and my
previous issues (shown in the above link). I really do not want to add
these
two users to the Admins group but I might have to so I can deploy this
database to another city (which I need to do fairly soon).

Thanks for any and all help!

Chris


.

Relevant Pages

  • RE: security wizard cannot be run
    ... I was fine with that until 'use your desktop shortcut'. ... for the Admin user. ... I tried to log on as Admin but couldn't get in to the database, ... Security permissions are stored in the mdb file. ...
    (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: 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: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)