We are attempting to work with a fictitious voter database. The database is MS Access
The database is said to contain TIF images of signatures in the column named SIGNATURE.
The organization providing the database says they extracted the TIF images from a binary blob column in SQL Server into a memo column in Access.
This appears to have changed each byte of the TIF image into a 16 bit charcter in the memo column. The first 3 bytes of a TIF image are II* (capital i, capital i, asterisk). The first six bytes in the memo field are I,null,I,null,asterisk,null. It does not appear that simply stripping the left bytes results in a well formed TIF image.
The organization providing the database is not being helpful with any more information. They don't know or won't bother to tell us how we might regenerate the binary TIF image from the memo column.
The project is to determine the method for extracting these TIF images to a Windows file system and to instruct us in that method. Proof that you have determined such a method will come from sending us one of the extracted TIF images.
We will upload a ZIP file containing the Access MDB database file. No password.