MS Access equiv of With(nolock)

  • Thread starter Thread starter macroapa
  • Start date Start date
M

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
 
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?
Click to expand...

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
 
macroapa said:
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
Click to expand...
 
macroapa said:
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
Click to expand...
 
Back
Top