FAO : Arvin Meyer - PictureMgr

[Matthew Therrien]

Dear Arvin

Many thanks for your reply. I had actually found your
Picture mdb the night before my posting ! Indeed, your mdb
does a lot of what I want - so that's a great start point.

Two comments/questions.

1. I understand that actually storing OLE objects in a a
table is not a good idea because of overhead/bloat. But
the technique I was proposing to use of inserting the
object into an OLE table field via the 'linking to' method
presumably carries very little overhead - only the file
and path name to the object being linked. Or am I wrong in
this assumption.

2. My main question from a knowledge-acquisition point of
view was/is - is it possible to discover or lookup the
file and path name of an object we insert into an OLE
image field ? That is to say - when we create from file
and link the object - we browse to the folder and insert
the object. We now have the object in our table field. So
can we now look up the file and path of that object and
then store it.

Many thanks for your help and your database.


Matthew

 

[Arvin Meyer]

Comments in-line:

Dear Arvin

Many thanks for your reply. I had actually found your
Picture mdb the night before my posting ! Indeed, your mdb
does a lot of what I want - so that's a great start point.

Two comments/questions.

1. I understand that actually storing OLE objects in a a
table is not a good idea because of overhead/bloat. But
the technique I was proposing to use of inserting the
object into an OLE table field via the 'linking to' method
presumably carries very little overhead - only the file
and path name to the object being linked. Or am I wrong in
this assumption.

Thats a technique that I used in Access 2.0, before there was an Image
Control. There is more overhead, but not as much as storing it in the
database. I prefer theImage Control because it is faster and more
trouble-free.

2. My main question from a knowledge-acquisition point of
view was/is - is it possible to discover or lookup the
file and path name of an object we insert into an OLE
image field ? That is to say - when we create from file
and link the object - we browse to the folder and insert
the object. We now have the object in our table field. So
can we now look up the file and path of that object and
then store it.

Yes it is, but it has been about 7 or 8 years since I've done it that way. I
don't have any of that old code around to refresh my memory.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access