>Hi,
>
>I have a database located in the path c:\wts\data\wtsdata.dbc,
>but the all DBF files of the wtsdata.dbc located in f:\wts\data.
>
>Now I want to move all DBF files to another location x:\wts\data
>
>I copy all the DBF file to x:\wts\data, but how to change the path in the wtsdata.dbc ?
>

First, it's not a good idea to keep a database and its tables in different folders. Many of VFP's tools rely on relative addresses and work best when the DBC and the DBFs are in the same folder.

I think the RENAME TABLE command will let you move tables and update the database at the same time.

You'll have to deal individually (or by writing some code) with any forms that include the tables in their Data Environments and so forth.

Tamar