Re: Probs accessing database for users of newly developed Superuse

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Chris,

Yes, I'm sure. I created the database several years ago and am modifying it
for my current company. I have only a little experience with writing code so
I wouldn't have come up with something that elaborate on my own. I have
received help with code from others but nothing to do with preventing certain
users from opening the db.

The only macros I have are for exiting the program, getting the user name,
launching Excel spreadsheets, and having Outlook send me an e-mail when the
user clicks a button. I took a look at the various pieces of code and I can't
see anything that might prevent certain users from opening the db.

Might something be corrupt?

Regards,
Chris

"Chris O'C via AccessMonster.com" wrote:

That message is normal for users who don't have administer permissions.

Since the superuser can get in by pushing the shift key when opening the db,
are you sure you don't have vba code or a macro running on startup preventing
certain users from opening the db?

Chris
Microsoft MVP


CB wrote:

I logged in as one of the users in Superuser and checked the accounts
window. Both users are listed as members of Superuser. Interestingly enough,
I accidently selected the User and Group Permissions window and when I tried
to select a group a dialogue popped up stating:

"You can't view this object's permissions. To view or change permissions for
this object, you must Administer permission for it. For more information on
permissions and who can set them, click Help."

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200810/1


.

Relevant Pages

  • Re: Probs accessing database for users of newly developed Superuse
    ... Both users are listed as members of Superuser. ... I accidently selected the User and Group Permissions window and when I tried ... "You can't view this object's permissions. ... this user is listed as a member of the superuser group. ...
    (microsoft.public.access.security)
  • Re: Username and Usergroup
    ... My question was actually for jokobe - as to why he/she feels they need to ... I can see if they are setting permissions on ... > You have a valid point about the security permissions for running queries ... >> So why are you trapping that when opening the db? ...
    (microsoft.public.access.formscoding)
  • Re: Ow! Dont put your Thumb there!
    ... Turn off thumbnails in Windows Explorer and stop opening your local FP site outside of FP ... | "Server error: The server extensions were unable to ... | Well, if I could find the file to check the permissions, ...
    (microsoft.public.frontpage.programming)
  • Re: field level security question
    ... different behavior based on whether you are opening a form based on a table ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • RE: Problems with saving a file back to its source location
    ... permissions or even if own docs via the MY Site functionality. ... This particular users document is opening in a browser. ... >> document has problems with saving the document back to its source location. ... >> The normal process is checkout, make a change, save and the user is ...
    (microsoft.public.sharepoint.portalserver)