PRB: Erroneous Error When Repeatedly Opening Database (200025)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 6.0
  • 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

  1. Set up a server machine and a client machine. Install Visual FoxPro 6.0 on the client machine.
  2. 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
  3. From the client machine, use Windows Explorer and map a drive K that points to a shared folder on the server machine.
  4. Create a database on the K drive using Visual FoxPro 6.0. This database does not need to contain any tables.
  5. 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.
Modification Type:MajorLast Reviewed:10/15/2003
Keywords:kbDatabase kbpending kbprb KB200025
©2003 Microsoft Corporation. All rights reserved.