[dba-SQLServer] Read only rights

jwcolby jwcolby at colbyconsulting.com
Sun Jan 9 23:50:50 CST 2011


OK, that would be a good thing!

Thanks for the reply!

Boy am I learning stuff on this project!!!

John W. Colby
www.ColbyConsulting.com

On 1/10/2011 12:15 AM, Stuart McLachlan wrote:
> I don't expect the same results in Access  :-)
>
> The query is Read Only, the problem is with your display interface.
>
> The SSMS interface doesn't retreive any information about the R/W status of the data that its
> displaying so it doesn't stop you from modify the *displayed* data.
>
> Access forms are smarter and lock the displayed data if it is RO.
>



More information about the dba-SQLServer mailing list