preventing update to linked SQL server database

  • Thread starter Thread starter jen
  • Start date Start date
J

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?
 
jen said:
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?
Click to expand...

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