rename database

[hmcheung]

I'm using VFP 6.0. I have a database with 3 tables inside. How can I rename the database? I tried to use

rename XXX.dbc to YYY.dbc

but the YYY.dbc can't be used because some kind of file (like .dct?) is missing. How can rename it at the same time retaining all the referencing files? Thanks! Please visit my WebCam!!

http://i.am/andycheung

 

[jonscott8]

Hi Andy,

FYI, a database consists of 3 files:

.DBC - The database container
.DCT - The database memo file
.DCX - The database index file

If the .DCX gets lost, VFP will recreate it. However, if you lose the .DBC or .DCT, you've got some work to do. Hopefully, you have a backup copy of the .DCT or have errantly misplaced it in another directory. For more info, check out the following article:

Resolving FoxPro "Memo File Is Missing/Invalid" Error

http://support.microsoft.com/support/kb/articles/Q94/3/48.ASP

If you do not need the database container or feel you can recreate it, open the tables directly(USE MyTable) and VFP will prompt you to delete the backlink to the database. Select <Delete> and the tables will be freed from the database and you can recreate a new database container and add your tables. Jon Hawkins
jonscott8@yahoo.com

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed