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

Brad Marks BradM at blackforestltd.com
Mon May 10 13:26:16 CDT 2010


Jack,

Thanks for the tip.

Brad

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jack and Pat
Sent: Monday, May 10, 2010 1:08 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 "Read Only" access to SQL Server 2005

Brad, 
I'm not a sql server dba or user, but I found this after seeing the
discussion with Rocky.
http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/6da145a8-2
d66-
4d8b-b584-4bbfcfa5408c
Hope it's useful.
jack

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Monday, May 10, 2010 2:00 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 "Read Only" access to SQL Server 2005

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.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.819 / Virus Database: 271.1.1/2864 - Release Date: 05/10/10
02:26:00


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