MS Access equiv of With(nolock)

[macroapa]

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

 

[Armen Stein]

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

 

[ANNNABORDA]

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

 

[o;;]

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