Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / September 2005

Tip: Looking for answers? Try searching our database.

Help needed with "Operation not supported in transactions" error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Moore - 29 Sep 2005 21:15 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.