Deny the column

[accessman2]

Hi,

I linked the SQL Server tables to MS Access. But, I want to prevent one column to read by user. I tried to create the standard role in SQL Server, and then deny one column, after that, I create the query which select the fields are read in the table only except the denied column, but the user get an error to open the query. How should I do it?

 

[Dennisk]

what is the error?

 

[boblarson]

Create a view in SQL Server which contains all columns except the one you don't want. Then link that view, instead of the table. I believe by restricting the column, and then trying to link to the table, Access isn't liking that and it is causing you the error.