Posted by laurenq uantrell on 10/20/70 11:27

I forgot to mention in my front end application (MS Access 2K) I use
the following:

On Error GoTo myErr:
' Execute the sproc that runs the Insert above
myErr:
CurrentProject.Connection.Execute "IF @@trancount > 0 ROLLBACK
TRANSACTION", , adExecuteNoRecords

I am wondering if this should be sufficient to not leave an open
transaction in the event of an error.

• Next in forum: Re: Connecting Trace info to blocked users?
• Prev in forum: Re: Blocking and Transactions OK?
• Thread view: Re: Blocking and Transactions OK?

[Reply to this message]