ADDING ATTACHMENTS TO INDIVIDUAL RECORDS: NEED SOURCES ON "HOW TO"

[Guest]

Does anyone have any "how to reference" ideas where I could get this info?

 

[John Nurick]

Hi Barkaroo,

I'd advise against storing the scanned images in an OLE field, because
in ordinary circumstances Access stores this data very inefficiently. A
better approach is usually to store the scanned images - or any other
external documents - as files on your hard drive, giving each a
consistent filename. Then store the names and locations of these files
in your database with the other customer details, either in a hyperlink
field or a text field.

These sample databases show relevant techniques:
PictureMgr: http://www.datastrat.com/DataStrat2.html
Larry Linson's: http://accdevel.tripod.com/imaging.htm

 

[Guest]

Hi John,
Thanks very much for the advice - I think that may be a better solution to
my problem. My dilemma is that my company will be going to a large Records
Management system within the next 3 years, and my data needs to be compatable
with the way the info will be stored on the SQL server. I'm going to check
with our IT dept. to see if what you are proposing is "doable". Thanks again
for you time. It's greatly appreciated. : )

Robin