[AccessD] Access 2007 "Read Only" access to SQL Server 2005

_______________________________________________________________________________________

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



If you pull the data into the forms as read only recordsets using ADO then they will never be able to write back to the table.

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, 11 May 2010 2:56 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 "Read Only" access to SQL Server 2005

Will setting the form properties Allow Additions, Allow Deletions, Allow
Edits to false do it?

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Monday, May 10, 2010 9:27 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access 2007 "Read Only" access to SQL Server 2005

Background.  Client = Small firm, no IT Staff, no DBA, purchased package
that uses SQL Server 2005.



Client wants to use Access 2007 to link to the tables in SQL Server in order
to create reports (via ODBC).



I have DB2 experience, but only limited experience with SQL Server
(especially in the security area).



What is the best way to ensure that no one working with Access will ever be
able to update any of the tables on SQL Server?  All users will be able to
see all of the data in all of the tables, we just cannot allow any updating
of data in the SQL Server tables.



I have read about a SQL Server "Fixed Database Role" called "db_datareader"



Is the use of db_datareader the best route to go?



Is there info on the web on how to set up and use db_datareader (or can
someone here explain the steps)



Thanks,

Brad
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.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.
_______________________________________________________________________________________