I have a database container 'SA' that includes a table 'saTests.dbf'. Previously, the table had the alias of 'Tests' but when I migrated the app to VFP7, I started having a problem with a form that had this table in its DE. When the app was run, the form could not find the 'Tests' table in the database and a dialog would come up requiring the user to locate the table.

In an attempt to correct this problem, I changed the alias of the table back to the default alias which corresponds to the name of the file (satests). I also modified the form to change all references from 'Tests' to 'satests'.

The form runs fine in the VFP7 environment but when the form is run from within the app, I get the same locate dialog that still wants the user to locate the Tests table. saTest in now in the DE of the form and its alias there is saTests, I have hacked the form and have found no references to the 'Tests' table, and I have even hacked the database container and have found no references to 'Tests' there either.

I use SDT to maintain the Database and tables and have found nothing that looks amiss there.

When I do a validate database, I get an unexpected dialog. First 2 lines are written to the screen:

Validate database SA:
Rebuilding structural index.... Index rebuilt.

Then a VFP7 dialog comes up, "Alias 'SATESTS' is not found"

After clicking on the OK button, another line is written to the screen:

Database container is valid.

satests is, of course, a table in the database as discussed above.

Does anyone know what going on here? Obviously, something has gotten corupted. Any suggestions on how this can be repaired?

Thanks very much,
Stan