BeginTrans, Committrans and rollback...

[*Vince]

Hi all,

it seems that I'm unable to use BeginTrans, Committrans and rollback when I use and ODBC to connect to a database in DAO ???

I generally use these with my Workspace objet, should I use
it with my Connection objet ?

What exactly is wrong with this...

Thanks

[kmchong]

Hi, Vince

I search the net for the rollback (I get the same problem
as you did), would you tell me whether you get the
answer?

Thanks

[PatOls]

You use the transactions from the WORKSPACE

Certain types of ISAM-databases used in a Jet-Workspace doesn't support transactions. You can check if your database supports by checking the Transactions property :

myRecordset.Transactions ;boolean return

//Patrick

[Nice]

did u try this with the DBEngine object?

[kmchong]

Nice,

I am not familiar with DAO, DBEngine etc,
can you post a source code sample?

Thanks