B
BARKAROO
Ok, I've tried these sites and downloaded the sample databases:
PictureMgr: http://www.datastrat.com/DataStrat2.html
Larry Linson's: http://accdevel.tripod.com/imaging.htm
It seems to be along the lines of what I want.
John's suggestion below is what I'm aiming for. However, what I really need
is for the "user" when viewing a particular record on a form, to have an
option allowing to view & add scanned documents that would be hyperlinked to
that record.
I tried to duplicate the forms (for my needs) but I think maybe my Access
Skills aren't advanced enough to do this. Does anyone know where I can get
this stuff "spelled out" for me? PLEASE HELP!
---------------------------------------------
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
PictureMgr: http://www.datastrat.com/DataStrat2.html
Larry Linson's: http://accdevel.tripod.com/imaging.htm
It seems to be along the lines of what I want.
John's suggestion below is what I'm aiming for. However, what I really need
is for the "user" when viewing a particular record on a form, to have an
option allowing to view & add scanned documents that would be hyperlinked to
that record.
I tried to duplicate the forms (for my needs) but I think maybe my Access
Skills aren't advanced enough to do this. Does anyone know where I can get
this stuff "spelled out" for me? PLEASE HELP!
---------------------------------------------
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