Hello,

I am using a GUI,made in VB6, that is the interface to change records in a database.

To gain access to the database I use DAO. (I am aware of the existence of ADO).

I have to update 4 tables that I have opend in a recordset.
I have to do this table by table and if anything goes wrong I need to be able to rollback to the initial state of the recordsets.

--> Sollution Transaction.

For the question:

A)
Shoul I Begin the transaction after opening the workspace , dtabase and before opening the four Recordsets("Tables").

OR:
B)Should I open the workspace, database and recordsets and then start the transaction ?

C)None of the above. In this case, in what way should it then be done.

thx for the info.
Greetz
Jabar