Microsoft KB Archive/99613

{|
 * width="100%"|

-

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a
 * Microsoft FoxPro for Windows, versions 2.5, 2.5a

-

SYMPTOMS
Error 108, &quot;File is in use by another,&quot; occurs if multiple workstations on a network perform a APPEND BLANK command simultaneously.

CAUSE
The database header is briefly locked by the APPEND command, preventing access by multiple users.

RESOLUTION
Either of the following methods can be used to solve this problem:

  Add a SET REPROCESS TO command as the first line of code in the program. For example:        SET REPROCESS TO 30   && Or appropriate interval. SELECT FOR i = 1 TO 1000 APPEND BLANK ENDFOR   Add an ON ERROR DO command as the first line of code in the program. Also add the required ON ERROR routine. For example:       ON ERROR DO ERRHANDL SELECT FOR i = 1 TO 1000 APPEND BLANK ENDFOR

PROCEDURE ERRHANDL * Get the error number. m.errcode = ERROR * Get the currently executing line of code. m.execline = MESSAGE(1) * Retry when error 108 occurs on APPEND BLANK. IF m.errcode = 108 .AND. UPPER(m.execline) = &quot;APPEND BLANK&quot; RETRY ENDIF 

MORE INFORMATION
This problem can be reproduced by allowing two or more workstations to execute the following code: 

  SELECT FOR i = 1 TO 1000 APPEND BLANK ENDFOR Additional query words: FoxDos FoxWin REPROCESS

Keywords         : Version          : Platform         : Issue type       :
 * }