jpeg images in Access

[billwilson]

Does Access work with jpeg naturally or do I have to load xtra conversion utilities. When I define the data type as 'ole object' and insert an object (in this case a .jpg image) into the field it states that a 'Microsoft Photo Editor 3.0 Photo' is in the field. Can I stil retrieve a jpeg or is it converted.

 

[JPeters]

Bill,
Well, I'm not sure if it is computer specific to whether you have some sort of jpeg support underlaying all programs or whether Access itself has jpeg support.. However, I'm almost 99% sure it's the latter. I just tested it out in a form and report ... the .jpg extension is read perfectly fine by access and the picture pops right up. You are trying to get the image to appear on a screen right? Not just place the image as an icon within the form? ... If that's the case it's really simple too. Just reply and I'll write a quick walk-through. (or one of the other smarties here will beat me to it) ;-) ... Have a good one.

-Josh
Wasting more of your valuable time...

 

[billwilson]

Josh
Thanks for responding. Actually my problem goes deeper. I pull data out of Access with ASP\Vbscript(actually fairly easy stuff). I am having problems with getting a jpeg out of Access onto a web page. The vbscript is straight forward but no images appear in the page. Any suggestions.

 

[Zeroanarchy]

Just a quickone as I know u are probably past this already, but here is some info that may be handy.

Jpeg files work perfectly fine in Access, two ways u can work with graphic pics.

1.To Embedded the file in the program. THe down side to this is u enlarge your program by 6* the picture size and this becomes a problem if you are trying to keep it small.

2. To save the pic in an outside directory and have the form look for it on load up, this is really helpful for backgrounds and general pics. If the system is fast enough it will not slow the form down.

anyway if u have anymore queries let me know.

 

[Francescina]

Following my technique with ASP and the display of JPGs that reside inside the MDB and not in their native format (/image-folder):

1. I integrate the JPGs locally into the MDB using the Grapics Wizard (thus there is no bloating effect).

2. I use an automatic FTP upload procedure wizard to
2.1. copy the open MDB
2.2. compact the copy
2.3. send it automatically to the web server

3. The display of the integrated JPGs requires some extra coding. Each "img src=.." has to refer to a special ASP page that searches the JPG in the MDB and then transforms it from the binary format to a its native format.

I use this system extensively. Especially my clients who are not very computer-litterate and have only few experience are extremely happy with it.
The usage of wizards allows them to work with a fully automated dynamic ACCESS/ASP application without having to worry about the complexity that lies behind it.

Furthermore, there are no orphan or missing JPGs on the website.

 

[TrevorEllis]

I use automatic ftp from an access database and I find it is swifter (and easier) to store image paths rather than actual images within the database. When the images are selected by the user a copy of the image is made to a folder and the path is stored in the database. When uploading the database is uploaded together with any images in the relevant folder. Hope this helps.