BeginTrans, Committrans and rollback...

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

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

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 :

Code:

---


myRecordset.Transactions ;boolean return

---

//Patrick

did u try this with the DBEngine object?

Nice,

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

Thanks