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,124
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,853
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.

--------------------
Doug Steele, Microsoft Access MVP (2000-2018)
http://www.accessmvp.com/DJSteele/AccessIndex.html
Co-author: Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs, published by Wiley
Co-author: Effective SQL: 61 Specific Ways to Write Better SQL, published by Addison-Wesley Professional
Technical Editor: Access 2010 Bible, Access 2013 Bible, Access 2016 Bible, all published by Wiley
Technical Editor: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition, published by Addison-Wesley Professional
Go to the top of the page
 
NineIron
post May 16 2018, 04:57 AM
Post#3



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


Thanx.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th August 2018 - 01:02 AM