Hello All,

I have a database included in an application. The application also opens an EXCLUDED database (different name then the included) with tables of the same name as the tables in the INCLUDED database. When executing a SQL SELECT against tables of the EXCLUDED database the application is selecting the data from the INCLUDED table.

When I include the name of the database in the SQL Select:

SELECT * from c:\data\servicedata!dataobjects

I get an error the table doesn't belong to the database. FoxPro is searching the executable before going to disk when performing the SQL Select. If I exclude one of the tables from the executable the SQL Select against the EXCLUDED table works fine.

The code has worked fine for years running as multiple executables. The code which accesses the EXCLUDED database and the code which uses the INCLUDED database use to reside in seperate executables.

Any ideas how to make FoxPro NOT use the INCLUDED table in a SQL Select?

BTW, the INCLUDED database is closed when executing the SQL against the EXCLUDED table.

Will