SQL Server lock on OpenRecordset

[SuryaF]

I have an Access db with linked tables and views from an SQL Server 2000 database.

When I'm opening a linked view with the DAO.OpenRecordset SQL Server locks the tables involved in the view.
I can see that in SQL Server Enterprise Manager.

1. How can I open the view without locking the tables? (I tried the dbReadOnly and dbForwardOnly options of the OpenRecordset but with no luck)

2. Is there any way to link the Views in a read-only mode? I never use Views for editing.

Thanks a bunch!

 

[PHV]

Ask the dba to revoke update, insert and delete permissions on this view for the connection's user.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886