General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only