Great! Thank you. Of course for this to work we would have to set the path to the location where the database is located.

>Something like this:
>
>open database ...
>?FILE(DBGETPROP(table_name,"TABLE","PATH"))
>
>>If I have a database: dbWorkFiles
>>
>>and I want to determine if one of its tables physically exist I would typically store a common path to the data directory to a variable like 'ddir' and then do:
>>
>>IF FILE (ddir+'mytable.dbf')
>>
>>However, if I do not know exactly where the tables are located - lets say I open them with:
>>
>>use dbWorkFiles!mytable
>>
>>then how can I check to see if the table exists or not if I do not know where they are located? Is that possible? It could be a part of the database but not physically exist...