R&R SQL Locking records in preview

[johnbprice]

When my R&R SQL 9.0.009 user has a report open and is in preview mode, the records in our SQL Server 2000 database are locked, and other users cannot modify records for data entry. It appears R&R keeps the selection open while in preview mode. Since R&R is inheritly read only, is there a way to make the R&R select not block other users?

[kfleming]

The problem has to do with transaction isolation level. If the ODBC driver you are using allows you to set an initialization string then try adding:__SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED____Kathleen__R&R Support