Re: Ugh! Permissions dilema...

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

That suggests that there is something in the form preventing the edits,
since you can edit the recordsource. check the code behind the form to see
if there is something locking things; also check the properties of the form
(allow edits, etc)

--
Joan Wild
Microsoft Access MVP

Bonnie A wrote:
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.
--
Bonnie W. Anderson
Cincinnati, OH


"Joan Wild" wrote:

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.

--
Joan Wild
Microsoft Access MVP

Bonnie wrote:
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!
--
Bonnie


"Joan Wild" wrote:

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.


--
Joan Wild
Microsoft Access MVP

Bonnie wrote:
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!
--
Bonnie


.

Relevant Pages

  • Re: Need to take ownership of word document
    ... Microsoft does not offer a service to ... Step 2 Use Save As to save a new document to edit ... Step 3 Check share permission ... the share folder as follows: ...
    (microsoft.public.office.misc)
  • Re: Ugh! Permissions dilema...
    ... Bonnie W. Anderson ... "Joan Wild" wrote: ... edit as my all-powerful self but when I log in as one of the RPSAdm ... i.e 'you do not have permission to use xxx object...' ...
    (microsoft.public.access.security)
  • Re: permission to edit fields
    ... when I create the outlook app. ... ASP, to impersonate a different user that has permission ... to edit rather than being the current windows user (so ...
    (microsoft.public.outlook.program_forms)
  • Re: How to give users ability to edit address lists from Outlook 02?
    ... give certain users the permission to create, delete, edit contacts in ... >> Is there a way to give admin staff the ability to update and edit ... >> I've set permissions via the group and Exchange address lists but when ...
    (microsoft.public.exchange2000.general)
  • RE: Documents open ReadOnly (Word 2003) even when "Edit in .." is
    ... Sharepoint server is in the list of Trusted sites. ... A specific subset of our customer's userbase cannot edit Sharepoint ... Once we assign them this permission, ...
    (microsoft.public.sharepoint.portalserver)