Connecting Tech Pros Worldwide Help | Site Map

Setting the isolation level

  #1  
Old January 24th, 2006, 01:15 AM
Robert
Guest
 
Posts: n/a
I am not sure if this is possible but can one set the isoation level on the
sql DB from a MS ACCESS session?


  #2  
Old January 24th, 2006, 11:35 AM
Terry Kreft
Guest
 
Posts: n/a

re: Setting the isolation level


Depends how your doing your updating. If your using SQl code on ADO
connections or using Pass-Through queries then yes, you just use standard
TSQL.

If you're talking about updating to linked tables then I don't see how you
can.


--
Terry Kreft



"Robert" <robert.j.sipe@boeing.com> wrote in message
news:ItKnAw.Do1@news.boeing.com...[color=blue]
>I am not sure if this is possible but can one set the isoation level on the
>sql DB from a MS ACCESS session?
>[/color]


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
setting isolation level read uncommited prakashgrp answers 0 November 26th, 2008 09:35 AM
Question about Transaction isolation level="readCommitted" D. answers 3 May 26th, 2007 11:35 AM
Transaction isolation level for stored procedures. kanda answers 2 December 22nd, 2005 01:05 PM
HELP! SET TRANSACTION ISOLATION LEVEL query. Eric Porter answers 3 November 15th, 2005 04:32 PM
Isolation level ignored when DTC is used yu_sha answers 9 November 12th, 2005 10:34 AM