D
Don
Hello, I have an Access 97 application that uses Pass-
Through Queries to a SQL Server 2000 database. I've
noticied some locking issues occur when running some of
the Pass-Through Queries.
The interface is a bound form to a linked table on the SQL
Server. When loading certain combos on this form it
invokes the Pass-Through query in RowSource property.
Even after loading the combos, the stored procedure in the
Pass-Through Query is still holding the lock. I would
think that the lock should be let go after the combo is
loaded.
Any thoughts or understanding on when the Pass-Through
lets go of the connection.
Thanks
Don
Through Queries to a SQL Server 2000 database. I've
noticied some locking issues occur when running some of
the Pass-Through Queries.
The interface is a bound form to a linked table on the SQL
Server. When loading certain combos on this form it
invokes the Pass-Through query in RowSource property.
Even after loading the combos, the stored procedure in the
Pass-Through Query is still holding the lock. I would
think that the lock should be let go after the combo is
loaded.
Any thoughts or understanding on when the Pass-Through
lets go of the connection.
Thanks
Don