David,

I lied. The DCT file is in the data dirctory also. Several times I have run VALIDATE DATABASE RECOVER in the data dirctory and just get the message that the index has be sucessfully rebuilt. As a test I created another program in another folder to open and browse one of the tables in the data directory using the SET PATH statement and it works fine. Arghh! It's just ignoring it in my application.

Stephen

>Stephen,
>
>You better have a DCX and DCT to go along with the DBC, otherwise you don't have a valid database container. The DCT is the memo file, the DBC is the table and DCX is the index file.
>
>>All of the DBF/DCX/TBK files are in the data folder. There aren't any DCT files. I tried your code in the MAIN.PRG and alternatively in the LOAD event of the Login Screen and only got an error that the dbc wasn't open. It appears that the SET PATH is being completely ignored by the application. Any additional hints.