Passthrough Query creates big record lock

HI,

I have a question. When I run a passthrough query in Acces, It creates a big lock on table tbl_Contacts.. The strange thing is that I only use this query for show, not for editing. Can anybody explain to me how this happens?? When I set the rowcount to 120 then No lock appears. But when I remove the rowcount, sometinh like 2000 locks appear in my Current Activity. The query without the rowcount returns 440 records..

Regards,


Guido


Query
----------------------
exec spCallScript_CallsToCall_CallActive 94,17, 1



SP
----
CREATE PROCEDURE spCallScript_CallsToCall_CallActive @ProjectID int, @ScriptID int, @CallActive int AS
--set rowcount 120
set nocount on

--Declare @ScriptID int
--select @ScriptID = 7

--1 = A: maximimale belpoginh
--2 = C: Completed Script
--12 = cllback
--5 = wrong call
--14 = broken call


SELECT
--tbl_Companies.ProjectID,
tbl_Companies.*,
tbl_Contacts.*,
CallContacts.ContactID
FROM
tbl_Companies INNER JOIN (tbl_Contacts LEFT JOIN (SELECT DISTINCT tbl_Calls.ContactID FROM tbl_Calls WHERE (((tbl_Calls.ScriptID)= @ScriptID) AND ((tbl_Calls.CallCode)=2 Or (tbl_Calls.CallCode)=1 Or (tbl_Calls.CallCode)=5 or (tbl_Calls.CallCode)=12 or (tbl_Calls.CallCode)=14) )) CallContacts ON tbl_Contacts.Contact_ID = CallContacts.ContactID) ON tbl_Companies.Company_ID = tbl_Contacts.CompanyID
WHERE
(((tbl_Companies.ProjectID)=@ProjectID) AND
((CallContacts.ContactID) Is Null) AND
--((tbl_Companies.CO_ProjectCode) ='1'));
--Die 2 is er ff tijdelijk bijgezet
((tbl_Companies.CallActive)=@CallActive or (tbl_Companies.CallActive)=2))
--((tbl_Companies.CallActive)=2))
order by
(tbl_Companies.CallActive) desc,
(tbl_Companies.co_postalcode);
GO