Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Corrupt .dbf file: Jobs

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Corrupt .dbf file: Jobs

    Is there anyway to perform maintenance on a corrupted .dbf file to reassemble the data or is it pretty much just lost?

    Alpha4v4

    #2
    RE: Corrupt .dbf file: Jobs

    Try opening the .dbf file in Excel or other program that supports opening the .dbf format.

    Once opened in Excel you should be able to view the file, delete any "bad data", and resave to a new name (with the .dbf extension).

    Also possible to create a new table with the structure of the old table, append records from the old to the new. May salvage records until the corruption is encountered.
    There can be only one.

    Comment


      #3
      RE: Corrupt .dbf file: Jobs

      YOU CAN USE THE ALPHA UTLILITY 'COPY DATABASE', BUT CHOOSE NOT TO INHERIT SUPPORT FILES.

      SO IF THE CORRUPT DATABASE IS CALLED 'HEADER.DBF', COPY USING THE UTILITY 'COPY DATABASE' IT TO A NEW ONE CALLED 'NHEADER.DBF' WITHOUT INHERITING SUPPORT FILES.

      THEN FROM DOS (BY PRESSING ALT + F9) RENAME THE DATABASE.

      REN HEADER.DBF AHEADER.DBF (RENAMES THE CORRUPT DATABASE TO AHEADER.DBF)

      REN NHEADER.DBF HEADER.DBF (RENAMES THE COPIED DATABASE BACK TO ITS ORIGINAL NAME)

      TYPE EXIT TO GO BACK TO ALPHA

      THEN UPDATE THE INDEX OF HEADER.DBF

      IF THE DATABASE HAS BEEN RESTORED, YOU CAN GO BACK TO DOS (ALT + F9) AND DELETE THE CORRUPTED DATABASE.

      DEL AHEADER.DBF

      Comment


        #4
        RE: Corrupt .dbf file: Jobs

        I need help too.

        Comment


          #5
          Re: Corrupt .dbf file: Jobs

          Hello Justin,

          Rule #1: Attempt recovery only on a *copy* of the damaged file.

          Can you be more specific about the database "corruption"? Does A4 just fail to open the bare .DBF file? Or does it open, but then shows gibberish in some of the records? Are the data "skewed" so that field data seems to spill over into an adjacent field? Can the corrupt .DBF file be successfully and accurately copied to another disk or directory?

          There are numerous utilities around that can automagically repair .DBF files, but you can still do some header repairs manually with a hex editor. In my experience, more often than not, the .DBF header gets corrupt, while most of the data are intact.

          In one application that I used to maintain (not an A4 application, but one that also used a .DBF file), its favorite way of corrupting the database was to fail to save a valid record count in the header, making the database appear empty. Correcting the record count easily repaired this kind of database damage.

          -moy

          Comment


            #6
            Re: Corrupt .dbf file: Jobs

            The tool, technically perhaps, is free...but it cannot be used for recovery unless you pay for it.
            The trial version has some limitations. You can use it to view the recovered data, but cannot export it to Microsoft Excel.
            This post looks very close to a spam advertisement, but maybe is a decent tool for $27 (personal) to $45 (business)?????? I just wanted to make sure users here don't fall for a salesman's hype (non-total disclosure).
            Mike
            __________________________________________
            It is only when we forget all our learning that we begin to know.
            It's not what you look at that matters, it's what you see.
            Henry David Thoreau
            __________________________________________



            Comment

            Working...
            X