A
Andreas Wöckl
Hi Group!
I have the following import function of an excel sheet in my project that
drives me cracy
public sub import()
On Error GoTo Err_perform
DoCmd.RunSQL "BEGIN TRAN Import"
' Work with Recordset import data and so on
' If everything is all right:
DoCmd.RunSQL "COMMIT TRAN Import"
Exit sub
Err_perform:
DoCmd.RunSQL "ROLLBACK TRAN Import"
MsgBox "Error at importing", vbCritical
end sub
If i produce an error I always get the error message that the rollback
transcation has no suitable begin transaction - but why?
any ideas?
best regards,
andy
I have the following import function of an excel sheet in my project that
drives me cracy
public sub import()
On Error GoTo Err_perform
DoCmd.RunSQL "BEGIN TRAN Import"
' Work with Recordset import data and so on
' If everything is all right:
DoCmd.RunSQL "COMMIT TRAN Import"
Exit sub
Err_perform:
DoCmd.RunSQL "ROLLBACK TRAN Import"
MsgBox "Error at importing", vbCritical
end sub
If i produce an error I always get the error message that the rollback
transcation has no suitable begin transaction - but why?
any ideas?
best regards,
andy