MS Access Connection to SQL Server causes blocking

[Colin Smith]

Hi,

I found a connection from MS Access to our SQL Server
Database which was readonly and only performing
a select caused other SQL Server connections to be blocked.

The server it was connecting to was also be replicated
to and the blocking appeared to affect the replication.

Any idea why a readonly connection would cause these
blocks ?

Cheers, Col.