Code works without Transaction, but not with
- From: "Jon Ley" <JonLey@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 11 Aug 2005 08:33:07 -0700
I am running some code to update many tables in my database, and I want an
'all or nothing' result. I am therefore performing all the updates within a
transaction. For some reason, I am encountering a situation where the code
(which usually works fine) is not working with one particular set of data. In
an attempt to debug the code I commented out the BeginTrans and CommitTrans
statements. All the data updated fine. With the transaction statements back
in place, the code runs through without any errors, however some of the
updates do not work (but some do).
I have tried all sorts of things - compact and repair both front end and
back end databases; decompile both databases. The decompile seemed to corrupt
the back end, so I created a new back end database, imported the table
definitions from the old back end (uncorrupted copy), then linked the old
tables into the new back end and transferred the data across. This cured my
corruption problem, but the transaction still does not work.
Anyone out there got any ideas? (Access XP, by the way)
.
- Follow-Ups:
- Re: Code works without Transaction, but not with
- From: Allen Browne
- Re: Code works without Transaction, but not with
- Prev by Date: AddNew not working - no error given
- Next by Date: Re: Code works without Transaction, but not with
- Previous by thread: AddNew not working - no error given
- Next by thread: Re: Code works without Transaction, but not with
- Index(es):
Relevant Pages
|
