Hi,

I have a VB 6.0 application that is a front end for an SQL Server database. The problem is than if an instance of the application uses the same form that uses another instance of the same application on another computer, on instance block the other an vice versa. When I update information on the server I use transactions. I tried all the options for cnn.IsolationLevel=X, but no result. If even the aplications tries to query a table that is opened with Entreprise Manager, the application is locked by the Entreprise Manager. If i close the table the problem is solved and the application is unlocked and it can query the table. THE TABLE IS OPEN FOR VIEWING, not for design or update.
Can anyone help me? Thanks.