sql data through access view only

[themase]

Hello all

does anyone know a away i can make the table i have linked to in a sql
server 'view only' in access so no one can change the real data just view it!

or is it just a case of using queries to display the data!

thanks in advance

 

[Paul Shapiro]

Give the user read-only permissions in SQL Server. Or you can create views
and give them read-only permission to the views without any permission on
the underlying tables.