Using Access with photos

[Rob]

I am developing an application in Access 2007. It is for a small, one man
business. In his business he will need to keep photos and or videos of
various pieces of artwork he creates (for brochures, 'reports' for customers,
etc). As well, he has another party who has designed a website for him,
where these same photos and/or videos will more than likely be used. Is
there a way for Access to store the images in a database or does that create
size and performance issues? I was thinking a possible route would be to
have the photos stored at a somewhat centralized location, then the website
could reference them while the Access database would store the paths to these
pictures and this value could be used as link property in the Access
application. Otherwise, would anyone know if there is existing software that
does somthing similar to this, at a relatively low cost?

Thanks

 

[Gina Whipp]

Rob,

Hmmm, long answer, many samples... so go here:
http://www.granite.ab.ca/access/imagehandling.htm Answers and samples!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Klatuu]

The optimum solution would be if you could put the images in a folder where
the web page can find them and your Access application can also find them.

Then use a text or better yet, a hyperlink field to store the paths to the
images.

You are correct about the issues of putting images in the database. In
Access, the most dangerous part is the 2Gig limit on an mdb or accdb.
Putting images in your database will blow that fairly quickly

 

[Tony Toews [MVP]]

You are correct about the issues of putting images in the database. In
Access, the most dangerous part is the 2Gig limit on an mdb or accdb.
Putting images in your database will blow that fairly quickly

Note that this is fixed in A2007. But now that I think about it I'm
not sure if they're fixed in the MDB file format as well as the ACCDB
file format.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/