sql data through access view only

  • Thread starter Thread starter themase
  • Start date Start date
T

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