Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

Re: Ugh! Permissions dilema...

Tip: Looking for answers? Try searching our database.



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.

Login | Free AccessMonster.com registration | Whole discussion thread

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 A25 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 Wild22 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

Bonnie22 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 Wild22 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

Bonnie22 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:

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.