Hi Jean-René.
>But if you have two DBC one in c:\MyData1 and one in c:\MyData2 which one is Open if you do this.
>
>Use C:\MyData1\MyTable in 0
>Use C:\MyData2\MyTable in 0
>
Both DBCs are open in that case. Neither one is selected (ie. DBC() returns an empty string).
>After this code you do this:
>
Use MyDBC!MyTable2 in 0
>
>From which directory MyTable2.dbf is open?
I looked into this several years ago, so my memory may be fuzzy, but I believe the DBC opened last is the one that's used in this case.
>Is there a way to control which DBC is Open?
You can control which one is selected by doing SET DATABASE TO (full path of the DBC). Then you can just USE MYTABLE rather than USE MYDBC!MYTABLE.
>Can I Open a table, which is part of the DBC, without opening the DBC?
No.
Doug