Microsoft KB Archive/141910

= BUG: Validate Database Dialog Allows Choice of Invalid Table =

Article ID: 141910

Article Last Modified on 11/1/2006

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q141910



3.00 3.00b 5.00 WINDOWS kbprg kbbuglist



SYMPTOMS
When Visual FoxPro detects that a table within a .dbc file has been deleted, the Locate file dialog box allows you to add an existing table from the same .dbc that has the identical structure as the deleted file. This file then appears in a Browse window with the name of the deleted file.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



MORE INFORMATION
If you try to modify or browse a deleted table contained in a database, Visual FoxPro detects that the file no longer exist. The Locate File dialog box appears and asks for the location of the missing table. If you choose a table that is part of the database and has the same structure as the deleted file, Visual FoxPro accepts that table into the database under the name of the deleted table. Visual FoxPro does not detect that you are adding a table already contained in the database container back in under another name.

Steps to Reproduce Problem
 Set the default to the \Samples\Data subdirectory and open Customer.dbf. Copy Customer.dbf to two files by typing the following in the Command window:

Copy to Test1.dbf

Copy to Test2.dbf.

 Create a database named Test.dbc. Add the Test1 and Test2 tables to the Test database. Type CLOSE ALL in the Command window to close all open files. Open either File Manager or Explorer, and delete the Test2.dbf file.</li> In Visual FoxPro, open the Test.dbc, and double-click Test2.dbf.</li> A Validate Database dialog appears stating:

The table 'Test2' cannot be found along the specified path. Would you like to locate the file or delete this object from the database?

</li> Click Locate, select Test1.dbf, and click OK.</li></ol>

Visual FoxPro opens Test1.dbf in a Browse window entitled Test2. However, the Locate dialog box will not add a table with a different structure from the same database or a table from another database. This triggers an error message.

Additional query words: VFoxWin kbbuglist5.00 buglist3.00 buglist3.00b kbvfp300 kbvfp500 kbvfp600

Keywords: KB141910

-

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

© Microsoft Corporation. All rights reserved.