MS SQL has (nolock) - Access?

  • Thread starter Thread starter trekkor77
  • Start date Start date
Maybe.

If you are working against a SQL-Server then you could use a passthrough
query with a NoLock hint.

While doing a little search on the Internet, I've also found the following
two solutions:

1- for a regular Jet database, you could add the Distinct keyword to your
query. It will make it Read-Only but at the same time, will permit Jet to
put much less locks on it. (Reference:
http://bytes.com/topic/access/answers/196349-access-sql-query-incompatability-nolock )
..

2- you can also use the Option on the JET "READ WRITE SHARE DENY NONE" if
this is MDB linked to another MDB. See
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_24072691.html

Finally, if you would explain what your problem is, maybe someone will come
with a solution.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)
 
Back
Top