Re: Error 1709 database object in used by someone else

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Thu, 16 Jun 2005 16:20:05 -0400, "Dennis Hevener"
<770-307-1511@xxxxxxxx> wrote:

>Hi--
>
>I am getting occasional errors
>
>1709 database object in used by someone else
>
>occasionally when doing
>
>USE vMyView nodata
>
>I can find almost nothing on this error anywhere. I would appreciate any
>input from others who know anything about this error.

We started getting this after we upgraded from VFP3 to VFP7 when using
remote views that are stored in a DBC opened by multiple users. It
appears that starting in VFP7, VFP holds something in the DBC
exclusive for a very short period of time when instantiating the
remote view (even though the DBC is open shared).

We got around it by checking for that error in our ON ERROR handler
and executing RETRY.

.