We have a datawarehouse on SQL 2000 were users are free to query using any
tools available. I have discovered that users who use Access 2002 Linked
Tables
and Queries hold Shared Locks on the SQL tables while they browse data.
This
subsequently prevents the replication task from inserting records into the
table. The replication holds an Exclusive Lock which prevents subsequent
new
queries from querying the table. All in all, the Access user blocks
queries
until he or she closes the table or query window.
The question is: is there any easy way to alter this behaviour in Access?
Is
it possible to change the ODBC or set something on the server that changes
the default isolation level to read uncommitted? Or do I have to use pass
through queries with (NOLOCK)????
Rgds
Bertrand
