Hi Gregory,

Sorry, my example wasn't a good one - I *was* in fact using full paths in all statements e.g:

OPEN DATABASE "C:\myPathA\myDBC"
OPEN DATABASE "C:\myPathB\myDBC"
SET DATABASE TO "C:\myPathA\myDBC"
USE myView   && View defined in myPathA\DBC "Select * from myDBC!myTable"
SELECT myTable    && Underlying table opened by View
? DBF()    && = myPathB\myDBC

If it's working for you maybe it's a version thing. My test was in VFP6 (haven't tried it in 7/8). What version were you using ?

BTW I notice that the ADATA() array always lists databases in reverse order of opening (i.e. most recent is first row)

Regards,
Viv