Rollbacktrans doesnt work. Why?

• zdenek douda

  SSC-Addicted

  Points: 419

  More actions

  October 14, 2004 at 5:24 am

  #66629

  Hi,

  I have procedure in excell and insert from there data to access table. I want to insert always all rows from excell sheet to access table or no rows. Insert work in loop and after last record I use commit, in other case (error) I use error handler - rollback. All works all right only transaction works bad. I thing problem is in connectionstring. How Must I edit connectionstring than transaction between excell and access works all right?

  cnct = "Provider = Microsoft.Jet.OLEDB.4.0; "

  Which  other parametr Must I use for good work.

  Thanks you very much.

  zdenek

• October 18, 2004 at 8:00 am

  This was removed by the editor as SPAM

• parag_c_mehta

  Grasshopper

  Points: 16

  More actions

  October 20, 2004 at 4:59 am

  #527295

  Can you post some working code so that we get an idea ?

  Secondly my guess is about connection, make sure you are using the same connection object. Transactions are based on the connection....

   

  HTH,

  Best Regards,

  Parag.

• parag_c_mehta

  Grasshopper

  Points: 16

  More actions

  October 20, 2004 at 4:59 am

  #527293

  Can you post some working code so that we get an idea ?

  Secondly my guess is about connection, make sure you are using the same connection object. Transactions are based on the connection....

   

  HTH,

  Best Regards,

  Parag.