The relative path to Member.dbf is stored in the dbc, so as long as the dbc is open and you haven't moved Member to a different relative path, everything should work. And it does sound as if the dbc is open, otherwise you'd be getting an error that the view itself isn't being found.

If you try to "USE lv_member" outside of your application, does it work? If not, is it possible you've moved the table to a different relative path location with respect to the dbc? IOW, maybe when you created the table it used to be in the same folder as the dbc, but now it's in a different folder?
---J

>Hi,
>
>>>Are you getting a different error -- about the table -- now? The reason I ask is that before you mentioned receiving a "database does not exist error" which means the database can't be located.
>
>No, I still getting error "File 'c:\mmortals\orionphysician\membership.dbc' does not exist.". And, membership.dbc is located in "C:\Testing\Advanco project\Advancodb\Membershipdata\Membership.dbc"
>
>What I see from debugging is, when VFP try to open my view - lv_Member, it try to locate the underlying table - Membership!Member.dbf. Since these data is not stored in .\Data, and not Set Path to "C:\Testing\Advanco project\Advancodb\Membershipdata\" ever called, then VFP can't locate to the file and cause error.
>
>Any ideas?
>
>Thank you