VB Forum / Database Access / August 2003

Hi,

USING VB.NET / SQL SERVER 2000 / ADO

I am currently writing a multi-user booking application.

I have a program which updates a group of clinics in a
clinic file, this can take a few minutes as there is a
lot of processing involved.

The problem I have is that we are doing all of this
within a transaction, the program loops through each
clinic and updates it, but once the first update has
processed it locks the entire clinic file. This results
in other users not being able to read any records from
the clinic file. (When I remove the transaction from the
code, everything works fine - but this is not good enough
for the application).

Is there a way not to lock the entire clinic file whilst
using transactions.

Thanks for your help

Dan