How to restore MDX file?

[IlyaRabyy]

Colleagues,

Say, an MDX file's been lost irrecoverably but needs to be restored, while DBF file's intact.

Is there possibility to restore it (that is - tag names and index keys' expressions) using the DBF's header (opening the latter with FOPEN() function)?

If not - any other ideas are welcome!


Regards,

Ilya

 

[AidenMc]

Ilya,
Just wondering what version of dbase you are using, if you could let me know
Thanks

 

[IlyaRabyy]

No prob'm: dBASE PLUS ver. 2.6.2 and/or dB2K 0.4 b1661.

Regards,

Ilya

 

[AidenMc]

Sorry Ilya,
I meant to ask whether you were running over novell or not, if you are you could use filer to restore the mdx, as far as I am aware you wont be able to get it back using the header and fopen() but thats not to say you can't
Aiden

 

[IlyaRabyy]

you wont be able to get it back using the header and fopen() but thats not to say you can't

That sounds a bit promising!
How?
Ehrr... No, it's not Novel, it's Win2003 Server. (And, honestly, I don't think it matters, does it?)

Regards,

Ilya

 

[AidenMc]

You could try the freeware from

http://www.sharewareconnection.com/software.php?list=Visual+Dbase+Full+Software

 

[dbMark]

An MDX file is just an "multiple index" file that can contain one or more indexes. It can be recreated since the only critical information you need are the "key" expressions and "tag" names. From those you can use dBase to recreate the file. Or if this is a table supported by an application a developer wrote, you may be able to find a menu item such as "Reindex tables" which will reindex the tables easily for you.

 

[IlyaRabyy]

So, IOW, there's no way possible to extract the info on the key expressions and tag names once the MDX file's been permanently lost?

Regards,

Ilya

 

[IlyaRabyy]

Have to re-post, sorry:

So, IOW, there's no way possible to extract the info on the key expressions and tag names once the MDX file's been permanently lost from any place other than the original program code (or printed documentation, if such "animal" exists and is available)?

Regards,

Ilya

 

[fishmahn]

IlyaRabyy,

That's correct. In the dBase table structure, there is a flag that says an MDX is supposed to exist, but all the details are in the mdx itself.

Mike.

 

[IlyaRabyy]

Oh, ssshacks! That's what I was afraid of!
Alrady, then, the case is closed.
Thanks to everybody who responded to this my enquiry.

Happy New Year to you and yours, colleagues!

Regards,

Ilya