You are accessing this site in a read-only mode. For full access to all member benefits, including message posting, please login or register. Registration is completely free, simple, and takes only a few seconds.
The message you are replying to and its parents are listed in the reverse order with the most recent posts first. This might not be the whole discussion thread. To read all the messages in this thread please click here.
Re: Ugh! Permissions dilema...
| Bonnie A | 25 Sep 2006 16:18 |
Hi Joan,
I have opened the linked table and the query as one of the administrators and have the same inability to edit. Have deleted the link and relinked it (tables are in a backend DB).
Should I try to create a new shell DB and import my objects?
Thanks very much for your help.
 Signature Bonnie W. Anderson Cincinnati, OH
> That is odd; I can't think of a reason for this. They obviously have open > permission on the form. [quoted text clipped - 50 lines] > >>> -- > >>> Bonnie |
| Joan Wild | 22 Sep 2006 22:06 |
That is odd; I can't think of a reason for this. They obviously have open permission on the form.
What is the record source for the form? Can you open it directly as one of the RPSAdm and see any records, or add/edit anything there?
If you can do that, check that there isn't some code behind your form causing the problem.
As for 'bad man', I suggest you just ignore it.
 Signature Joan Wild Microsoft Access MVP
> Hi Joan, > [quoted text clipped - 39 lines] >>> -- >>> Bonnie |
| Bonnie | 22 Sep 2006 19:27 |
Hi Joan,
Thanks very much for your inquiry. I get no message. It simply will not respond. There is no status bar message or dialog box. I can edit as my all-powerful self but when I log in as one of the RPSAdm group I can edit some forms and this one I cannot. I place the mouse in the field and there is no response to my keystrokes.
P.S. What should I do about the reply I got above from 'bad man'? He doesn't offend me, he's just showing himself to be a twit. Is there any way for the PTB's to block foul posting addresses from our newsgroups?
Thanks again!
 Signature Bonnie
> What is the specific error message? That usually tells you the object you > need to focus on. [quoted text clipped - 18 lines] > > -- > > Bonnie |
| Joan Wild | 22 Sep 2006 19:03 |
What is the specific error message? That usually tells you the object you need to focus on.
i.e 'you do not have permission to use xxx object...'
What are the permissions on that object? Does that object have any lookup fields - (yet another reason to avoid them); users need permission on the lookup table.
 Signature Joan Wild Microsoft Access MVP
> Hello everyone. I'm using A02 on XP. DB is an old A97 that was > converted up to A02. Have a user group with edit rights and they [quoted text clipped - 9 lines] > -- > Bonnie |
| Bonnie | 22 Sep 2006 15:59 |
Hello everyone. I'm using A02 on XP. DB is an old A97 that was converted up to A02. Have a user group with edit rights and they work fine on one form but not on another. I cannot figure it out! I've checked the permissions from the DB to tables to queries to forms. If I give someone in the group admin rights, all is well but I can't do that for everyday permissions. Just can't figure out what I'm missing. Is there some glitch I'm not aware of? Must I create a new empty DB and import all my objects? I've been fighting with this for hours!
Thanks in advance for any advice!
 Signature Bonnie
|
Quick links: