BUG: Validate Database Dialog Allows Choice of Invalid Table (141910)


The information in this article applies to:

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

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

    Copy to Test1.dbf
    Copy to Test2.dbf.

  3. Create a database named Test.dbc.
  4. Add the Test1 and Test2 tables to the Test database.
  5. Type CLOSE ALL in the Command window to close all open files.
  6. Open either File Manager or Explorer, and delete the Test2.dbf file.
  7. In Visual FoxPro, open the Test.dbc, and double-click Test2.dbf.
  8. 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?

  9. Click Locate, select Test1.dbf, and click OK.
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.
Modification Type:MajorLast Reviewed:12/16/2003
Keywords:KB141910
©2003 Microsoft Corporation. All rights reserved.