By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,030 Members | 1,231 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,030 IT Pros & Developers. It's quick & easy.

Nesting Transactions with SQLServer 2000 and Access97

P: n/a
I am trying to use transactions in Access97 and SQL Server 2000. A
simplified version of the program I am writing in Access is as follows:

Begin Transaction
Begin Transaction
Import File in Tble1
Commit Transaction
Begin transaction
Merge Table1 and tble2
commit transaction
Commit Transaction

It seems that SQLServer will NOT allow me to nest transactions in this
way. Is this correct. Is my only choice to unnest the transactions?

In the above exmple, my transaction is controlled by the currentdb.
Would it make a difference if I set a variable equal to the SQL server
connection and tried to control the transaction that way?


Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.