Liveware Publishing Support Forum

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?

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