multipage tiff

[bbouwer]

Hi,

I have converted a DMS system into MS ACCESS,to give people the possibility to search for documents.All the data around the docs are in the database,eg the field DOCID contains a docid corresponding to a tiff file with the name of this docid.One can run a search,select a record,and click a button to view a file.
Here's my problem,in most cases behind records are more tiff-files stored,sometimes upto 100 pages,how can i view these 100 pages.

Format off a 3 pages tiff-document :

DOCID 1.001
DOCID 2.002
DOCID 3.003

Tried combining them into one multi-page tiff file,but did not succeed using VBA.

Maybe i can display them all in a form as a thumbnail ? doubleclicking on it opens this page ?

Mabe someone has another idea or option,please let me know,

Regards,

Bert.

 

[Galaxiom]

I would investigate storing the multipage tiffs as BLOBs (Large binary objects) in the database.
Reading them would be accomplished by invoking a multipage tiff reader like Brava and passing the file to it.

Basically Access extracts the blob to a temporary file then opens it in the reader.

 

[bbouwer]

Hi,

Thanks,but all the files are single page tiffs,if behind a record more than one file is stored,i have to view them one by one,that´s my problem.I am searching for a solution to view them as multipage tiff,by only using vba access,i can´t use third-party software,it´s forbidden.

Thanks,

Bert.