Access ADP with Images stored within SQL 2005

[pwilliams]

Does anyone have any code/suggestions/techniques/links for displaying
images stored within a SQL 2005 database on forms or report and also
how to get images into the database? I know a lot of people like to
store just the path to the image in a file directory but I recently
came into some new information about SQL 2005 at a Learning Tree class
and it has excellent ability to handle large data types. In a MDB file
the OLE object data type can be used very easily and by just dropping a
object frame into a form or report presto the image is there. But
using an ADP seems much more difficult. Please let me know if anyone
has experience with this.

 

[Sylvain Lafontaine]

To my knowledge, there is no difference between MDB and ADP: you use the
same kind of OLE object and images are stored as OLE object in the database
in a image field.

Needless to say that many people will prefer to buy or use some other
active-x controls like dbpix and stores images as true images instead of OLE
objects.