Results 1 to 9 of 9
  1. #1
    Join Date
    May 2010
    Posts
    4

    Unanswered: Help needed: corrupted archive in Code Bank

    I have a problem when reading the Excel Automation V4 zip file by Pootle Flump in dBforums Code Bank thread from the link: http://www.dbforums.com/6222281-post4.html/. When I save a zip file to a local drive and attempt opening it with WinRAR 3.62 there comes an error message "Unexpected end of archive". I asked the author and he told me he is able to run the file ok also suggesting I should post in here to get a quicker response maybe. Can somebody pls send me the contents of this zip file? Thanks a lot in advance!

  2. #2
    Join Date
    May 2010
    Posts
    601
    I had no trouble downloading the ZIP and opening it with WinRAR.

    I made a .ZIP using WinRAR and attached it here.
    Attached Files Attached Files
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    May 2010
    Posts
    4
    Thank you for posting this zip. I can open the zip file but what I get inside is a file ExcelAutomation without an extension. Do you have an idea what is it? Thanks

  4. #4
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by clubhead View Post
    Thank you for posting this zip. I can open the zip file but what I get inside is a file ExcelAutomation without an extension. Do you have an idea what is it? Thanks
    The ZIP file contains only this file:

    ExcelAutomation.mdb

    Sounds like you have file extensions set to not display.

    What is the icon for the file in Windows Explorer?
    Is it an Access icon (key)?
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  5. #5
    Join Date
    May 2010
    Posts
    4
    The settings are set to show file extensions. I could figure the file might be an mdb as mdb file format stores the name of the file inside (you can read it with a hex editor). Even if I force MS Access to open the file the error tells me the file is not recognized as an Access db. Can you pls post here the actual mdb? Or maybe send it to my email box? Thank you

  6. #6
    Join Date
    May 2010
    Posts
    601
    I have tested the original download on over 10 machines using the built in Windows support for unzipping without any issues.

    I suspect that there maybe some issue with the machine you are using.

    What software did you use to unzip the file?
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  7. #7
    Join Date
    May 2010
    Posts
    4
    Used WinRar 3.62 and Windows built-in zip. Same result.
    We could either try to find the reason of zip malfunction or you could send me the mdb unarchived. What do you say about the latter option? Thanks

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi clubhead

    I hope you received my response to your email about this some days (weeks?) ago.

    As per Boyd's experience, it extracts fine for me everywhere I have tested (not 10 machines I admit!).

    Boyd could try uploading with the .mdb extension changed to .txt or I could do so later (about to run)

  9. #9
    Join Date
    May 2010
    Posts
    601
    Sure ... here is the mdb renamed to have a .txt extention.

    Hope this works ...
    Attached Files Attached Files
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •