openrowset with readonly

• Sergio Campos

  SSC-Addicted

  Points: 459

  More actions

  December 11, 2007 at 5:50 am

  #377451

  Hi,

  i want to use openrowset to connect with readonly access to a mdb database.

  i have created a view like:

  SELECT *

  FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'MS Access;Database=\\ruta\base.mdb;UID=Admin;PWD=admin', 'SELECT * FROM tabla')

  AS derivedtbl_1

  that i've name as "empleados"

  But if i type "update empleados set campo1=1" it update field. how could i conect with openrowset but with only read.

  Many thanks

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  December 11, 2007 at 6:39 am

  #758924

  Connect with a user that has more restricted rights to the file.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning