See
Re: Error 1709 object in use error Thread #
661693 Message #
661773>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
If it's not broken, fix it until it is.
My Blog