Status of transaction

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi guys,
I am using Access 2000 to write a conversion process that takes info from a number of regularly received external spreadsheets and collates it.

I am using BeginTrans/CommitTrans/Rollback properties and am wondering if there is anyway I can find out what the status is i.e whether a BeginTrans has been started or not - something along the lines of BeginTrans.Status

Cheers
Tony
Error 746 - Divergent Temporal Instability
 
I don't think there is.

If there was, it would be a workspace property, since a transaction applies
to all databases in the specified workspace.

Personally, I set a boolean "in transaction" flag before I begintrans, &
clear it immediately after I rollback or commit. This is because
rolling-back when not in transaction state causes an untrappable error! So
in an error handler, you can't just say on-error-resume-next/rollback,
because that will die if you are not in transaction state.

HTH,
TC


Hi guys,
I am using Access 2000 to write a conversion process that takes info from a
number of regularly received external spreadsheets and collates it.

I am using BeginTrans/CommitTrans/Rollback properties and am wondering if
there is anyway I can find out what the status is i.e whether a BeginTrans
has been started or not - something along the lines of BeginTrans.Status

Cheers
Tony
Error 746 - Divergent Temporal Instability
 
Answered elsewhere.

DO NOT MULTI-POST!!

CROSS-POST!

See: http://oakroadsystems.com/genl/unice.htm

TC


Hi guys,
I am using Access 2000 to write a conversion process that takes info from a
number of regularly received external spreadsheets and collates it.

I am using BeginTrans/CommitTrans/Rollback properties and am wondering if
there is anyway I can find out what the status is i.e whether a BeginTrans
has been started or not - something along the lines of BeginTrans.Status

Cheers
Tony
Error 746 - Divergent Temporal Instability
 
Back
Top