×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to restore MDX file?

How to restore MDX file?

How to restore MDX file?

(OP)

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

RE: How to restore MDX file?

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

RE: How to restore MDX file?

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

Regards,

Ilya

RE: How to restore MDX file?

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

RE: How to restore MDX file?

(OP)

Quote:

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

RE: How to restore MDX file?

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.

RE: How to restore MDX file?

(OP)
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

RE: How to restore MDX file?

(OP)
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

RE: How to restore MDX file?

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.  

RE: How to restore MDX file?

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close