Re: Set column level permissions in Access adp
From: Michael (email@example.com)
From: "Michael" <firstname.lastname@example.org> Date: Wed, 19 Mar 2003 13:15:44 -0800
I checked using sp_who and the login being used currently
by the adp is my own. I have explicity denied UPDATE
priveleges on the column in question for my login so I am
perplexed as to why I can still go into the adp and update
the column value. It seems like I should receive some type
of warning message regarding insufficient priveleges for
update on that column. Any other thoughts come to mind?
>I don't know much about ADPs, but do check your connect
string, if there's
>You can always find out the login name used by your ADP
by running sp_who in
>SQL Server. Look at the login name column of the output.
You could also
>trace it using SQL Server Profiler.
>Vyas, MVP (SQL Server)
>"Michael" <email@example.com> wrote in message
>How can I tell which login my adp is using? Any
>suggestions would be welcome!
>>Then your ADP is probably not using the same login, that
>has been denied
>>permissions on this column.
>>Vyas, MVP (SQL Server)
>>"Michael" <firstname.lastname@example.org> wrote in message
>>I have an Access adp project (Access 2000 version) that
>>connects to a SQL Server 2000 DB using WinNT
>>authentication. I need to lock down one column in a table
>>so that only one specific user can update data in that
>>column. Setting user permissions on this column in EM
>>not seem to have any impact on a user's ability to update
>>or change values in that column via a form in the adp
>>project. What am I missing here or doing incorrectly?