preventing update to linked SQL server database

[jen]

I have set up an ODBC connection between Access and a SQL
Server database. I want to give some users the ability to
build Reports in Access against the SQL Server database,
but not to be able to update the data.

Is this possible? If so, how do I go about it?

 

[Rick Brandt]

I have set up an ODBC connection between Access and a SQL
Server database. I want to give some users the ability to
build Reports in Access against the SQL Server database,
but not to be able to update the data.

Is this possible? If so, how do I go about it?

On the server grant them Select permissions, but not Update or Delete.