Read in External data

[Dan @BCBS]

I'm searching for a "simple" example of Reading in an external file (.tiff or
jpeg etc.)
Then saving it to a table so I can link it to a record.

Suggestions?

 

[mscertified]

You are better off keeping those files external to Access and just saving
their location (file path) in an Access table. You can then use a hyperlink
to view them.

Dorian

 

[Daniel]

Only store the file path with the filename in your db. Do not embed them
into your db! For more inf look at

http://www.mvps.org/access/forms/frm0030.htm

Basically whether it be a word doc, excel spreadsheet, image,... they all
get handled the same way. I would suggest you look at a few image sample dbs
to take inspiration, such as:

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#images
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album
http://www.rogersaccesslibrary.com/download3.asp?SampleName=Pictures.mdb
http://www.rogersaccesslibrary.com/download3.asp?SampleName=PicturesLoad.mdb