Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DAO and Transactions

Status
Not open for further replies.
Reggie36

Reggie36

Programmer
Aug 11, 2000
3
US
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]
 
Sort by date Sort by votes

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]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
496
strongm
strongm
sal21
  • Question
loopimg link and downlosd zip file 1
Replies
3
Views
202
strongm
strongm
wires
  • Question
Install VB6 IDE and Access97 on W11 ARM version 1
Replies
3
Views
345
Gabor526
G
sal21
  • Question
API REST get zip cod efrom street name and city
Replies
1
Views
187
strongm
strongm
Ken01
  • Locked
  • Question
Areas under graphs and overlap areas between circles. 2
Replies
3
Views
712
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top