[AccessD] Read only rights

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________


Bah, stupid outlook sent this when I wasn't done.  As my 2 yo would say "Try again..."


A basic fix would be to

1: set the form in MS Access to read only OR
2: use a read only recordset to show the data in Access

based on their SQL Sever Permission status.

Although I would imagine a better solution would be to have the change at the SQL Server level itself - which is what you want I would imagine.  In the past I have usually used one of the two above methods though

Cheers
Darryl


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, 10 January 2011 4:08 PM
To: Access Developers discussion and problem solving; Sqlserver-Dba
Subject: [AccessD] Read only rights

I created two users to test the rights I assigned and how they function, straight in SQL Server. 
One is read and one is read and write.

The read / write operates as expected, however the read only allowed me to modify but not save the 
modifications.  Somehow I expected the query to be readonly.

Again this was directly in a SQL Server table, logged in to SSMS through that user.

I expect the same results once I get to getting at the data from Access.  Is there a way to prevent 
even the appearance of modifying the data if the user is read only?

-- 
John W. Colby
www.ColbyConsulting.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________