D
Der Segler
Hi all
I would appreciate any tip related to the following scenario:
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 don’t want to issue
shared locks or exclusive locks. I want to be able to read an uncommitted
transaction or a set of pages that are rolled back in the middle of a read
and a Dirty reads should be also possible. Is there any thing similar to
“nolock†in MS Access? If so, what is what I need to do in order to make this
happen? Any ideas?
I would appreciate any tip related to the following scenario:
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 don’t want to issue
shared locks or exclusive locks. I want to be able to read an uncommitted
transaction or a set of pages that are rolled back in the middle of a read
and a Dirty reads should be also possible. Is there any thing similar to
“nolock†in MS Access? If so, what is what I need to do in order to make this
happen? Any ideas?