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 - 29 Sep 2005 22:36 GMT
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

Signature
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 - 30 Sep 2005 01:19 GMT
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.
> I have a tabbed form with various subforms. Under certain
> circumstances, when the user tries to delete a record on the subform
[quoted text clipped - 10 lines]
>
> TC