DAO and Transactions

[Reggie36]

Hi,

I am writing code for a multiuser VB app with an Access/DAO database (it's always been that way). In a number of functions transactions are indicated. Does anyone know what effect transactions have on performance, and how significant it is?

[sig][/sig]

 

[listener22]

I would guess that the main effect of using transactions in Access is that
locks are going to stay in place longer. That could cause contention,
depending on the no. of users and what they are doing. If you use transactions,
and you don't get complaints from the users, then I wouldn't worry about it.
JOTTOMH.
[sig]<p>Jim<br><a href= > </a><br>oracle, vb, some javascript[/sig]