Using Access with photos

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
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
 
Klatuu said:
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
Click to expand...

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/
 
Back
Top