cancel
Showing results for 
Search instead for 
Did you mean: 

OLEDB - Connection string Readonly option

VijayKumar6
Level 3
Looking for an option to set Readonly attribute in connection string while using OLEDB utility. Currently its throwing an error if file is opened by someone else. Any inputs would be much appreciated.   Thanks Vijay
3 REPLIES 3

VijayKumar6
Level 3
I have already tried MODE=Read;ReadOnly=true

blue_meanie
Level 6
Mode=Read; used to work fine on a Win7 platform, but have noticed it no longer opens files Read Only since migrating to a Win10 platform, which is annoying!

Denis__Dennehy
Level 15
Can this not be done on the db side rather than the OS side? Most enterprise databases can set user permissions so a user will have read only access rather than update/insert permissions.