It is possible by specifying the DBC - complete with path. I just tested it by opening 2 DBCs and then opening the same table in each. I can browse both the tables, although the second one to be opened was assigned an alias by VFP.

You can open and refer to a DBC by the full path:

Open data D:\App1\MyDBC
Open data D:\App2\MyDBC

Next open tables

Sele 0
use D:\APP1\MyDBC!MyTable
Sele 0
use D:\App2\MyDBC!MyTable

Again, assign your own alias to the second table opened so VFP doesn't do it for you.

Note the "!" that separates the DBC name from the Table name.

HTH
Barbara



>When you issue SELECT mytable, is there any way to specify the DBC? This would be important if you had 2 DBCs open and both DBCs had a table with the same name.
>I've tried SELECT "MyTable!MyDBC" but VFP does not accept this.
>Unless there is some way to do this, I could use the work area number to select the table I want.
>Thanks, Chaim