Open .msg, .tif, .pdf and other files from Access

[Christer]

I intend to write an archive application, where you can
save different type of files in common folder. (Notice that
Outlook .msg file will be located in the arcive folder
outside the mail system).
An Access database contains information about files in the
archive and different properties are connected to each
file.
A search engine let the user find files in the archive
that meet certain criteria and properties.

How does the code looks like to open appropriate program
to show or print a file independent of filetype.
Especially I want to handle .msg, .tif, .pdf and .jpg -
files.

Looking forward to any suggestions.
Christer

 

[Eric Lawrence [MSFT]]

http://www.mvps.org/access/general/gen0015.htm

This should work for most any file type.

--
Thanks,

Eric Lawrence
Program Manager
Assistance and Worldwide Services

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Wei-Dong Xu [MSFT]]

Hi Christer,

I'd suggest you can try the method Eric suggested. Please feel free to let
me know if you have any further questions. I am standing by to be of
assistance.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.