>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)?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison