>>>Hi All
>>>
>>>I have a table with an associated cdx. If I delete the cdx file and open the table in VFP IDE the table opens normally and the status bar says that the "structural cdx reference has been removed". This is fine.
>>>
>>>When I delete the cdx and try and open the file from within my exe app then an error occurs. How can I avoid the error and allow my app to open the file normally but just without the cdx file?
>>
>>Don't know if it's what you want to do, but IIRC DELETE TAG ALL on an open table completely deletes the .CDX.
>
>Hi Al. Yes I know but my question was if the cdx file is already missing then it generates an error when opening the dbf in an app or exe. Sergey has offered some solutions in this thread. Thanks.
OK, I read your original message to mean you wanted to purposely delete your own .CDX file. When in fact, you want to recover from the condition where the .CDX has already been badly damaged, deleted or is otherwise unavailable.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up