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

Rocky Smolin rockysmolin at bchacc.com
Mon May 10 11:55:32 CDT 2010


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




More information about the AccessD mailing list