BCullenward
Registered User.
- Local time
- Today, 14:45
- Joined
- Jul 6, 2005
- Messages
- 28
I am setting the rowsource of a combobox/datagrid at run time to speed up processing, is there a way to specify NOLOCK or something similar to prevent lockups?
I'm having some lock-up problems where processes on SQL Server 2k get behind a process sitting on a select statement that isn't too advanced causing timeouts and everything in access to run slowly.
Would I need to set the queries to be pass thru queries then just call them from the code? (ie. a select * from books inner join authors on books.authorid = authors.authorid) is what was originally typed in code but make a pass-thru query with (Select * from books (NOLOCK) INNER JOIN Authors (NOLOCK) ON Books.AuthorID = Authors.AuthorID) saved as the query qry_AuthBook
then in the code set the rowsource to be
"Select * from qry_AuthBook"
I'm having some lock-up problems where processes on SQL Server 2k get behind a process sitting on a select statement that isn't too advanced causing timeouts and everything in access to run slowly.
Would I need to set the queries to be pass thru queries then just call them from the code? (ie. a select * from books inner join authors on books.authorid = authors.authorid) is what was originally typed in code but make a pass-thru query with (Select * from books (NOLOCK) INNER JOIN Authors (NOLOCK) ON Books.AuthorID = Authors.AuthorID) saved as the query qry_AuthBook
then in the code set the rowsource to be
"Select * from qry_AuthBook"
