How to edit gzip'ed binary files in Access 2010 using VB Script

Posted on 2014-07-11
Last Modified: 2014-07-24
I have a table containing a field with binary data,
Field is Gzip format and if unziped the content is  XML.

I need to read this field,
unzip the XML data,
edit the XML data
Save the edited XML back to Gzip
Save the Gzip data back to the binary field

The update needs to be done on more than 1000 records
The database is not part of any reporting services

Have you seen any good examples doing this?
Looking for a example to get me going.
Question by:Tom
    LVL 25

    Accepted Solution

    You might try zlib
    LVL 9

    Author Closing Comment

    Thank you so much for this grate tip!

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    730 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

    16 Experts available now in Live!

    Get 1:1 Help Now