>>Is there anyway to open up two databases with the same name, one on the local machine, one on a remote machine? There is no 'ALIAS' clause in the 'OPEN DATABASE' statement so that makes it almost impossible to refer to the two databases distinctively.
>>
>>Thanks for your help,
>>
>>Valter
>
>Sure it will be confusing to VFP. You can open two database with the same name simultaneously, however you have to use SET DATABASE TO fulldatabasepath to select the particular one. Even if you do this, the table from the database which was opened first will be USEd if you address it
>
>USE myDatabase!myTable
>instead of
>USE "s:\mynetworkdirectory\data1\myDatabase!myTable"
>
>May be you can try to open the databases with the same name in different Private datasessions (if appropriate)?

I agree, this is very confusing and inconvenient to not have an option to open database with alias. May be it should be added to a wish list?