You're probably right. I just wanted to see if there was some native VFP way before I coded it.

Thanks



>What's wrong with the way you're doing it? That's about the way I would code it (fleshed out with saves/restores etc.). I would make it a method or function with the DBC and table names as parameters and the fully qualified filename as the return value.
>
>
>>I have opened a DBC as a table, and for the objects that are Tables, I don't see how to determine
>>the physical location of a table.
>>
>>I guess I could do:
>>
>>

>>
>>CLEAR
>>CLOSE DATABASES ALL
>>
>>sDbc = "Y:\VTC_DEVELOPMENT_FOLDER\VTCDEV\data\vl_bill.dbc"
>>
>>SELECT 0
>>USE (sDBC) ALIAS MyDbc
>>
>>SELECT ObjectName;
>>	FROM MyDbc;
>>	WHERE ObjectType == "Table" AND;
>>		  NOT DELETED();
>>	INTO ARRAY aTables
>>
>>USE IN MyDbc
>>
>>OPEN DATABASE (sDbc)
>>
>>IF TYPE("aTables", 1) # "U"
>>
>>	FOR EACH sTable IN aTables
>>	
>>		SELECT 0
>>		USE (JUSTSTEM(sDbc) + "!" + sTable) ALIAS MyTable
>>		
>>		? LOWER(DBF())
>>	
>>		USE
>>	
>>	ENDFOR
>>
>>ENDIF
>>
>>RETURN
>>

>>
>>Is this possible to determine the table's location some other way?