-----Original Message-----
Hi,
Transactions may only be nested 5 levels deep; from the Jet programmer's
handbook:
"In Microsoft Jet workspaces, you can have up to 5 levels of transactions
active at any one time by nesting combinations of the BeginTrans and
CommitTrans methods or the Rollback method. If you nest transactions, you
must make sure you commit of rollback the current transaction before trying
to roll back or commit a transaction at a higher level of nesting. If you
want to have additional levels of nesting or want to have transactions with
overlapping, non-nested scopes, you can open additional workspace objects
and manage other transactions within those objects."
Please feel free to reply to the threads if you have any questions or
concerns.
Sincerely,
Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <
www.microsoft.com/security>
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "niraj shah" <
[email protected]>
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Hi Alick,
|
| Thanks for your reply. I am using ADO.NET with
| Provider=Microsoft.Jet.OLEDB.4.0 & Access 2000
|
| I am not sure if there is any limit for nested transaction
| in Access 2002. If so, is there any other way around?
| Please help.
|
| Thanks
| Niraj
|
| >-----Original Message-----
| >Hi,
| >
| >If you use ADO.NET, you would use Microsoft OLE DB
| Provider for SQL Server
| >(OLEDBSQL); if so, it is by design, OLE DB Provider for
| SQL Server does not
| >allow nested transactions.
| >
| >PRB: "Cannot Start More Transactions on This Session"
| Error Message When
| >
http://support.microsoft.com/?id=316872
| >
| >This question seems more like ADO.Net related. You can
| also try
| >Microsoft.public.dotnet.* newsgroup.
| >
| >Please feel free to reply to the threads if you have any
| concerns or
| >questions.
| >
| >
| >
| >Sincerely,
| >
| >Alick Ye, MCSD
| >Product Support Services
| >Microsoft Corporation
| >Get Secure! - <
www.microsoft.com/security>
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights.
| >
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "niraj shah" <
[email protected]>
| >| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
| >|
| >| Hi;
| >|
| >| I am working with OLEDB.NET provider and MS Access 2000.
| >|
| >| I am getting exception when i=4...
| >|
| >| try
| >| {
| >| System.Data.OleDb.OleDbConnection conn =
| >| ps.GetConnection();
| >| conn.Open();
| >| System.Data.OleDb.OleDbTransaction topT =
| >| conn.BeginTransaction();
| >| System.Data.OleDb.OleDbTransaction tempT = topT;
| >| for(int i=0; i < 10; i++ )
| >| {
| >| tempT = tempT.Begin();
| >| }
| >| }
| >| catch( Exception e )
| >| {
| >| System.Diagnostics.Trace.WriteLine( e.Message );
| >| }
| >|
| >| Does Access 2002 has same limit for nested transaction?
| >|
| >| Thanks
| >| Niraj Shah
| >|
| >
| >.
| >
|
.
