Microsoft KB Archive/200025

= PRB: Erroneous Error When Repeatedly Opening Database =

Article ID: 200025

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Data Access Components 2.5

-



This article was previously published under Q200025



SYMPTOMS
If you open a database located on a server numerous times from multiple Visual FoxPro 6.0 executables, then the following error randomly appears:

This file is incompatible with the current version of Visual FoxPro. Run 30UPDATE.PRG to update the file to the current version.

This error may also occur if you are opening a Visual FoxPro 6.0 database using ADO or the Visual FoxPro ODBC driver.



RESOLUTION
Use any ON ERROR procedure, such as the one in the code example in the MORE INFORMATION section below, to trap for the spurious error.



MORE INFORMATION
This behavior does not occur in Visual FoxPro 5.0x.

Steps to Reproduce Behavior

 Set up a server machine and a client machine. Install Visual FoxPro 6.0 on the client machine.  On the client machine, create a project and build an executable containing the following code: CLEAR ON ERROR DO Errorhandler WITH ERROR, MESSAGE KEY=0 OPENED=0 errored=0 DO WHILE KEY=0 OPEN DATA k:\robert SHARED OPENED=OPENED+1 @1,1 SAY "Opened:" + STR(OPENED) @2,1 SAY "Errored:" + STR(errored) CLOSE DATA KEY=INKEY(1) ENDDO QUIT

PROCEDURE Errorhandler (nError, messx) errored=errored+1 @3,1 SAY nError @4,1 SAY messx RETRY ENDPROC  From the client machine, use Windows Explorer and map a drive K that points to a shared folder on the server machine. Create a database on the K drive using Visual FoxPro 6.0. This database does not need to contain any tables. Go to the client machine and start at least four instances of the Visual FoxPro executable created in step 2 using Windows Explorer. You many need to start more instances to recreate the problem.

Depending on the scenario, the error may appear quickly or it may take several minutes.

Additional query words: kbDSupport KBDSE

Keywords: kbdatabase kbprb kbpending KB200025

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.