How do I use linked SQL Tables

G

Guest

Hi all
We have an Access dB with several native tables and one linked SQL 2000
table. I just need to read the SQL table (Query) and want to use the SQL
"nolock"
in Access. What is what I need to do in order to make this happen? Any ideas?

Fritz
 
V

Van T. Dinh

Just do a normal Select Query and in the Query Property, select "Snapshot"
for Recordset type and "No Locks" for Locking.

Alternatively, you can use a Pass-Through Query since Pass-Through Queries
are Read-Only.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Best way to deploy Access read-only database that is linked to SQL tables 6
MS Access equiv of With(nolock) 3
Access stripping decimal places in query 1
Linked SQL table 4
How do you use a checkbox with a linked SQL Server 2005 table? 5
linked table from ACCESS 3
linking from access to SQL tables 4

Top