I think I know the answer, but I am going to ask the question anyway...

scenario:

VFP application (6.0) running against sql server 2000 database

Remote views in database that is shared by users

Problems are being encountered when multiple workstations hit the same view-whoever gets there first runs fine, subsequent workstation locks until the first user exits the view.

What are the solutions - what is the problem?

TIA