>>>>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?
>
>I am sure Foxteam always meant to open another copy of the same database INSTEAD rather than simultaneously.

If this is the same database, it's probably not allowed to open it twice in the same DS. But if they are two separate databases (one on Disk D and another on Disk G), we have to have a way to open them both and easily differentiate them. Here ALIAS option would be really handy.