Column permission being ignored by Access Form Combo box

14 Jul 2006 6:51 PM

kellysc

I have a table linked to an access mdb which I have set permission on
for a specific set of users to update, delete, etc and another set of
user to only select, but I need these users to be able to change one
other field in the table.

I have set the permissions and all works well, but for some reason one
of the fields that should be select only is updatable.

It appears it's related to a bound control in a form that is being used

as a combo box with a row source populating it from another linked
table.

All in all I can't see why the row source and the combo box should
create this problem, but all other fields work as I would imagine.
Only this field is a problem.

14 Jul 2006 7:06 PM

Arnie Rowland

Probably better to post Access related issues in :

   microsoft.public.access.forms
   microsoft.public.access.formscoding
   microsoft.public.access.security

or one of the other 25 or so Access groups at microsoft.public.access.

--
Arnie Rowland
"To be successful, your heart must accompany your knowledge."

Show quote

"kellysc" <kell***@apci.com> wrote in message
news:1152903088.921798.85260@b28g2000cwb.googlegroups.com...
>I have a table linked to an access mdb which I have set permission on
> for a specific set of users to update, delete, etc and another set of
> user to only select, but I need these users to be able to change one
> other field in the table.
>
> I have set the permissions and all works well, but for some reason one
> of the fields that should be select only is updatable.
>
>
> It appears it's related to a bound control in a form that is being used
>
> as a combo box with a row source populating it from another linked
> table.
>
>
> All in all I can't see why the row source and the combo box should
> create this problem, but all other fields work as I would imagine.
> Only this field is a problem.
>

14 Jul 2006 7:08 PM

kellysc

Never mind I was testing with an account that had sa privs.

14 Jul 2006 7:17 PM

Arnie Rowland

Thanks for following up your own post. It prevents others from wasting their
time trying to help you after you have solved the problem, and it helps
others when you share your solution.

--
Arnie Rowland
"To be successful, your heart must accompany your knowledge."

Show quote

"kellysc" <kell***@apci.com> wrote in message
news:1152904120.746302.299690@i42g2000cwa.googlegroups.com...
> Never mind I was testing with an account that had sa privs.
>