-
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
-
May not be supported
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