[dba-SQLServer] Read only rights

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.
>