I have a passthrough query of the simple form 'SELECT * FROM tbl_A'.
Locking behavior caused by even simple passthrough select queries. In this context I have encountered what I think is strange I'm working with a split Access application where we're currently migrating the back-end to SQL Server, which we hope will help us to make the application more scalable in a multi-user scenario.