OPEN DATABASE myPathA\myDBC OPEN DATABASE myPathB\myDBC SET DATABASE TO myPathA\myDBC USE myView && View defined in myPathA\DBC "Select * from myDBC!myTable" SELECT myTable && Underlying table opened by View ? DBF() && = myPathB\myDBCSo VFP has selected from the table in the last opened database rather than the current database ! I know that hardcoding the path into the view definition would avoid the problem but it's not an option in my current situation and I've yet to find an alternative solution.