I have a big problem concerning Pessimistic locking in ADO.

I have done a small form that open an Access table using a pessimistic locking connection. When running 2 instances of this application it runs as supposed (the 2 instances can browse the same record at the same time but only one can update the record).

I use exactly the same application but this time using MS SQL Server 7.0 (only the ConnectionString property is changed). Big surprise here. When I run 2 instances, both instances cannot browse the same record (even if no locking is current)! I receive a timeout run-time error on the second instance which try to read a record in browse by the first instance.

Can somebody help me please?