Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2005

Tip: Looking for answers? Try searching our database.

Images in forms don't show anymore

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jerome Smith - 23 Mar 2005 14:38 GMT
Hello all,

I have an Access application with a table with an OLEDB field, in which
photographs are linked. The photos are shown in a form. This worked well for
many years and now suddenly it doesn't show the photo automatically any
more. You have to double click on it.

After installing Office Photo Editor you can now see the photos, but now we
cannot link them; they have to be embedded, which means that we are coming
up to the 2 Gb limit.

Anybody know how to solve this?

Thanks in advance,

Jerome Smith
Mark - 23 Mar 2005 15:24 GMT
Instead of storing the photo in the database as you are doing now, store the
full path to the image file in a text field.  I had inherited a database for
printing ID badges that was over 300Mb.  After changing it to only store the
paths and not the images, the database went well under 5Mb.

This has been talked about in numerous posts, so a quick search for phrases
like "Linking Images", "Storing photos in database", etc. should give you
some good information.

> Hello all,
>
[quoted text clipped - 14 lines]
>
> Jerome Smith
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.