Hello:

I have a problem the occurs occasionally where
VB 4.0 Pro tells me that I am NOT in a transaction,
where that is impossible! This is done on a Access 97
database.

I have code such as:

DBEngine.Workspaces(0).BeginTrans

< lots of processing here >

DBEngine.Workspaces(0).commitrans

this works 99.9999% of the time, but that one time
the Commitrans says that I am not in a transaction.

When this happens, all my updates ARE written to the database,
like I want, but the committrans blows up.

Is there a way that I can tell if my BeginTrans took, and
that I am actually "in a transaction" ?

Darryl Minsky
Calgary, Alberta, Canada