Approach - File may be damaged

Posted on 2005-05-11
Last Modified: 2010-05-18
Upon finishing some work in Approach v9.7, I compressed as I periodically do.  Now upon opening the file I get the following message:
Record header size 0x2EA3C13 bytes too small.  There followed a similar one with different numbers about bytes being too big.

Question by:bens-grill
    LVL 45

    Expert Comment

    1. Don't compress the file in future. Hard disks are now very large and inexpensive. Compressed files slow down access to them.

    2. Try opening the file with Lotus or Excel, clean it up and re-import it into Approach. If that fails try opening it with Wordpad and doing the same.

    LVL 3

    Accepted Solution

    This error message is referring to the APR file and not to the databases. Evidently the last time you saved the APR file, it did not save completely. Look at the file using Windows Explorer and you will see it is probably very small.

    Your only option is to get a backup copy of the APR file and restore it to replace the damaged one. If you do not have a backup, you will need to design the APR application from scratch.

    As for compressing the databases, you do not need to do this unless you have one of two conditions:
    1) You delete a lot of records -- the space is reclaimed when you compress the database.
    2) You have problems with Finds where the wrong records show up. In this case compression will rebuild the indexes. It may not totally "fix" them, but it is a good first effort at fixing them.

    I do not recommend regular compression of databases if you do not have the above conditions.

    Sue Sloan

    Author Comment


    I'm very grateful to you.  Thank you so much.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Title # Comments Views Activity
    Send email lotus notes / VBA 6 159
    Switching from Lotus Notes to Outlook 4 36
    Lotus Notes Calendar Issue 5 86
    Lotus Domino server 9 7 57
    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now