Multiuser application and Recordset

[ykfc]

Before I try to work out how I should implement locking in a multiuser environment. I want to clarify how my openrecordset statement works. In an MS Access application I create a recordset and process some data with:

Sub myProcess()
Dim rcdSet as DAO.recordset
set rcdSet=currentdb.openrecordset("select * from myLinkTab where country='xxx'")
rem.. process the returned record
rem may edit or delete records it has selected
rcdSet.close
End sub

myLinkTab is a linked table to SQL server Database. If the second user is adding new records to the linked table with country="xxx" while myProcess is still running, will myProcess have a chance to work on those records created by the second user at all?

Is the answer different if I use ADO instead of DAO? Thanks so much.