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

Brad Marks BradM at blackforestltd.com
Mon May 10 12:59:58 CDT 2010


Rocky,

Yes, that will probably work, but I was thinking that it would be nice
to have the "read only" restriction controlled centrally.  That is why I
was interested if others had used "db_datareader" to learn if that would
do the trick.

Thanks,
Brad 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, May 10, 2010 11: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

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.





More information about the AccessD mailing list