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