UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> No Locks On Linked Tables, Access 2007    
 
   
NineIron
post May 15 2018, 11:43 AM
Post#1



Posts: 2,120
Joined: 18-September 03
From: Massachusetts


Is there a way to put a NO LOCK on tables that are linked to SQL SERVER?
Go to the top of the page
 
Doug Steele
post May 15 2018, 01:22 PM
Post#2


UtterAccess VIP
Posts: 21,736
Joined: 8-January 07
From: St. Catharines, ON (Canada)


On tables? I don't believe so. It should be possible to create pass-through queries (using something like SELECT * FROM Person.Contact WITH (NOLOCK) WHERE ContactID < 20), but of course they'd be read-only.

--------------------
Go to the top of the page
 
NineIron
post May 16 2018, 04:57 AM
Post#3



Posts: 2,120
Joined: 18-September 03
From: Massachusetts


Thanx.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    26th May 2018 - 05:12 AM