Chris,
Here's the snippet from XXERROR.PRG in VMP4 that handles 1709 errors.
******************************************************************
CASE "," + alltrim(str(gnErrorNumber)) + "," $ ",1709,"
******************************************************************
*
* error when attempting to access a .DBC database object
* at the same moment as another user (usually due to
* attempting to open a view, in which case this error
* is already trapped when opening the view via oLib.oDBCSvc.OpenTable)
*
IF x3msgsvc("Server busy, keep trying?") = "Y"
retry &&& try again
lcAction = "NOTHING"
ENDIF
HTH.
>Am encountering the 1709 error (database object in use by someone else) error when a form is called by two people at the same time. The threads i've read indicate that is due to contention w/ the DBC when the views are querried during form load.
>
>When i encounter this error, VFP says the error is 2005 but gives the message() for 1709 as contained in the VFP help file.
>
>My VMP 3.01 version of XXERROR.PRG does not have a reference to 1709 or 2005. Could u check your VFP4 version of XXERROR.PRG to see if there is code to address 1709/2005? Is there a RETRY? Can u post the snippit if there is?
>
>TIA
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?