Help needed with "Operation not supported in transactions" error

[John Moore]

I have a tabbed form with various subforms. Under certain
circumstances, when the user tries to delete a record on the subform
they get an error, WITHOUT the error number, that says "Operation not
supported in transactions." If they click OK the delete completes
properly. However, being users they are concerned.

I know the error number for this is 3246 and have tried everything I
can think of to trap it without any luck. In addition, I can find no
BeginTrans code anywhere in these forms or code. Is there anyway to
trap this and, if so, how?

Any and all help is appreciated.

TC

 

[David Lloyd]

John:

I don't have enough information to know whether the following KB article
applies to your situation, however, I thought I would make you aware of it.

http://support.microsoft.com/default.aspx?scid=kb;en-us;295229

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a tabbed form with various subforms. Under certain
circumstances, when the user tries to delete a record on the subform
they get an error, WITHOUT the error number, that says "Operation not
supported in transactions." If they click OK the delete completes
properly. However, being users they are concerned.

I know the error number for this is 3246 and have tried everything I
can think of to trap it without any luck. In addition, I can find no
BeginTrans code anywhere in these forms or code. Is there anyway to
trap this and, if so, how?

Any and all help is appreciated.

TC

 

[David C. Holley]

Your starting point is the manner in which the users delete the record.
Are they clicking a button that calls code? Do they select the record
and then select DELETE from the Edit method? Also, have you witnessed
the SPECIFIC steps to reproduce the error? It may be that you need to
push back to them that you are aware of the problem BUT that they *MUST*
provide with the specific steps up to the problem. As a developer, you
can't just sit around trying to figure out the steps yourself. There
could be a milltion different combinations of actions and data values -
only 1 of which results in the problem.

 

[John Moore]

David,

Thanks for your response. The program deletes a record from the
datasheet view of a subform by highlighting the record and then using
the keyboard delete key. That fires the Form_onDelete event of the
subform. The main form is a tabbed form and when you go to another tab
and then return to delete a record from the subform on thie original
tab you get the error. I can repeat the error as often as I want but
cannot trap it.

JM