Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to restore MDX file?

Status
Not open for further replies.
IlyaRabyy

IlyaRabyy

Programmer
Joined
Nov 9, 2010
Messages
572
Location
US

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
 
Sort by date Sort by votes
Ilya,
Just wondering what version of dbase you are using, if you could let me know
Thanks
 
Upvote 0 Downvote
No prob'm: dBASE PLUS ver. 2.6.2 and/or dB2K 0.4 b1661.

Regards,

Ilya
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
you wont be able to get it back using the header and fopen() but thats not to say you can't
Click to expand...
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Amricain
  • Locked
  • Question Question
DBase IV how to save my stock in a new table
Replies
1
Views
716
Phil Thoms
Phil Thoms
ixodid
  • Locked
  • Question Question
Unable to open full DBF file in Excel...
Replies
13
Views
3K
BenskieV
BenskieV
bgavin
  • Locked
  • Question Question
Bug Fix for Software Science Topaz for Delphi v9.0.11 Insufficient Disk Space #227
Replies
0
Views
552
bgavin
bgavin
Rick C. Hodgin
  • Locked
  • Question Question
.FIL files
Replies
6
Views
1K
Mike Lewis
Mike Lewis
RONJ HARRIS
  • Locked
  • Question Question
How do I translate PROW() from dbase5 into dbase9 so as not to get an error?
Replies
0
Views
487
RONJ HARRIS
RONJ HARRIS

Part and Inventory Search

Sponsor

Back
Top