Re: Access and equiv of Transact-SQL's Nolock hint?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 13:29:53 -0500

"MGFoster" <me@privacy.com> wrote in message
news:RLfHc.9544$oD3.5181@newsread1.news.pas.earthlink.net...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Use pass-thru queries w/ the T-SQL NOLOCK hint.
>
> Don't you think that's kinda dangerous - reading an uncommitted
> transaction might result in invalid data returned in your query 'cuz an
> uncommitted transaction might be rolled back.
>
> Why don't you just test your queries in the SQL Query Analyzer & see
> what their times are, then set the Access query Timeout property to a
> little over that time?

Depends (as usual). I have had to use NOLOCK on a few occasions where I
was using a data table as the source of a ComboBox RowSource. Without
NOLOCK use of the ComboBox would impose a lock on the source table until
the last row of the list was accessed. Other users trying to make edits
against that table would then be blocked. Adding NOLOCK cured the problem. 

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Relevant Pages

  • RE: Combo box bound field change
    ... Modify the row source to include both fields. ... Make the bound column the company name column. ... now you can change the company name any time and your query ... Make a copy of your transaction table, but copy only the structure, not the ...
    (microsoft.public.access.forms)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • RE: Combo box bound field change
    ... now you can change the company name any time and your query ... Make a copy of your transaction table, but copy only the structure, not the ... Modify the New transaction table and change the company name field to ... I'd run a report to show what all that company purchased. ...
    (microsoft.public.access.forms)
  • RE: Combo box bound field change
    ... You do want the companynbr field rather than the company ... now you can change the company name any time and your query ... Make a copy of your transaction table, but copy only the structure, not the ... I'd run a report to show what all that company purchased. ...
    (microsoft.public.access.forms)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... is possible for others to add other new orders to the database which I will ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)