Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MS Access equiv of With(nolock)

1,361 views
Skip to first unread message

macroapa

unread,
Jun 29, 2009, 5:39:31 PM6/29/09
to
Hi,

I have a SQL server db where a query in SQL Query Analyser is written
as:

SELECT *
FROM Table1 WITH (nolock)

Now I have an ODBC link to this table in MS Access and want to have
exactly the same select query which at no point locks any of the data.

MS Access doesn't appear to have a WITH (nolock) command. What would
the equivalent be?

Thanks

ANNNABORDA

unread,
Jul 11, 2009, 9:18:11 PM7/11/09
to

"macroapa" <macr...@hotmail.co.uk> wrote in message
news:8244d742-644d-46b4...@h2g2000yqg.googlegroups.com...

Armen Stein

unread,
Jul 11, 2009, 12:23:59 PM7/11/09
to
On Mon, 29 Jun 2009 14:39:31 -0700 (PDT), macroapa
<macr...@hotmail.co.uk> wrote:

>SELECT *
>FROM Table1 WITH (nolock)
>
>Now I have an ODBC link to this table in MS Access and want to have
>exactly the same select query which at no point locks any of the data.
>
>MS Access doesn't appear to have a WITH (nolock) command. What would
>the equivalent be?

You can use NOLOCK in a Passthrough query.

I've written a PowerPoint presentation on techniques for using Access
as a client-server front-end to SQL Server databases. It's called
"Best of Both Worlds" at www.JStreetTech.com/Downloads. It includes
some thoughts on when to use SQL Server, performance and security
considerations, concurrency approaches, and techniques to help
everything run smoothly.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

o;;

unread,
Oct 1, 2009, 9:02:40 AM10/1/09
to

"macroapa" <macr...@hotmail.co.uk> wrote in message
news:8244d742-644d-46b4...@h2g2000yqg.googlegroups.com...
0 new messages