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

Stuart,

Thanks for the help.

I really appreciate it.

Brad

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

Alternatively - don't use integrated security.  Create a single user wit
a db_datareader role 
and set up your ODBC connection using that login and password.

-- 
Stuart


On 10 May 2010 at 14:10, RANDALL R ANTHONY wrote:

> If they have access to the tables in data sheet view, forms security
won't work.
> 
> You're heading down the right path, Brad.  You need to add the users
> to the security>users, then you can go to the properties of the users
> and add them to the db_datareader role. 
> 
> -----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 
> 

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