473,881 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Strange Access 97 Behavior in Displaying Images

At first I was not certain what could cause Access 97 from displaying
most jpeg images, but not all. After further testing, it seemed that
all original images of less than 275 pixels per inch or less would
display, but those close to 300 pixels/inch or greater would not (MS
Access cannot recognize the file format xxx.jpg). The larger, original
images were scanned and saved as .bmp (at 300 dpi producing a 15MB
file). Then the images were saved as .jpg's around 1MB, and adjusted
downward, but no luck. However, MS Photo Editor would open the larger
jpeg file size images consistently.

Is this strange behavior or what? Has anyone experience this problem?
Any insight and tips will be appreciated. Thanks.
Nov 12 '05 #1
3 3486
No, I have not. And I believe I have displayed some 1 MB or near-1 MB JPG
files. Were you displaying in OLE Frames or Image controls? If the latter,
there's no question in my mind that the "graphics filters" are less capable
than typical image processing software, such as MS Photo Editor.There are
sample databases at http://accdevel.tripod.com that illustrate three
approaches to handling images in Access.

Larry Linson
Microsoft Office MVP

"Dalan" <ot***@safe-mail.net> wrote in message
news:50******** *************** ***@posting.goo gle.com...
At first I was not certain what could cause Access 97 from displaying
most jpeg images, but not all. After further testing, it seemed that
all original images of less than 275 pixels per inch or less would
display, but those close to 300 pixels/inch or greater would not (MS
Access cannot recognize the file format xxx.jpg). The larger, original
images were scanned and saved as .bmp (at 300 dpi producing a 15MB
file). Then the images were saved as .jpg's around 1MB, and adjusted
downward, but no luck. However, MS Photo Editor would open the larger
jpeg file size images consistently.

Is this strange behavior or what? Has anyone experience this problem?
Any insight and tips will be appreciated. Thanks.

Nov 12 '05 #2
The core issue is that all non Bitmap/DIB Images are converted to
Enhanced Metafiles before they are displayed in the Image control. For
certain versions of WIndows there is a 16MB limit on any embedded DIB's
within the metafile. I cannot find my original notes but I think any
native JPEG larger than around 2200 *2200 would fail to load.
To get around this issue either:
1) Upgrade the OS to XP
or
2) Convert your JPEG's to Bitmap/DIB
or
3) Use the LoadJpegGif solution on my site which bypasses the Office
Graphics filters.
http://www.lebans.com/loadjpeggif.htm
A97LoadJpegGif. zip is a database containing a function to allow for the
Display of Jpeg and Gif files on systems that do not have the Office
Graphic Filters installed. Here is the A2K version: A2KLoadJpegGif. zip

NEW - April 05 2003 Ver 5.0 Developed to allow Access RunTime
installations to display Jpeg files in a standard Image Control.
Provides functionality to load JPG,GIF,BMP,EMF ,WMF,CUR and ICO files on
systems without the Office Graphics Filters loaded.
Originally developed for Systems with Access Runtime only. Supports
transparency in Transparent Gifs. Allows you to resize Images on
Forms/Reports at runtime with no loss of Image quality.

FInally take a moment to read the Image FAQ on my site here:
http://www.lebans.com/image_faq.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Dalan" <ot***@safe-mail.net> wrote in message
news:50******** *************** ***@posting.goo gle.com...
At first I was not certain what could cause Access 97 from displaying
most jpeg images, but not all. After further testing, it seemed that
all original images of less than 275 pixels per inch or less would
display, but those close to 300 pixels/inch or greater would not (MS
Access cannot recognize the file format xxx.jpg). The larger, original
images were scanned and saved as .bmp (at 300 dpi producing a 15MB
file). Then the images were saved as .jpg's around 1MB, and adjusted
downward, but no luck. However, MS Photo Editor would open the larger
jpeg file size images consistently.

Is this strange behavior or what? Has anyone experience this problem?
Any insight and tips will be appreciated. Thanks.


Nov 12 '05 #3
"Stephen Lebans" <Fo************ *************** *************@l invalid.com> wrote in message news:<3S******* **************@ ursa-nb00s0.nbnet.nb .ca>...
The core issue is that all non Bitmap/DIB Images are converted to
Enhanced Metafiles before they are displayed in the Image control. For
certain versions of WIndows there is a 16MB limit on any embedded DIB's
within the metafile. I cannot find my original notes but I think any
native JPEG larger than around 2200 *2200 would fail to load.
To get around this issue either:
1) Upgrade the OS to XP
or
2) Convert your JPEG's to Bitmap/DIB
or
3) Use the LoadJpegGif solution on my site which bypasses the Office
Graphics filters.
http://www.lebans.com/loadjpeggif.htm
A97LoadJpegGif. zip is a database containing a function to allow for the
Display of Jpeg and Gif files on systems that do not have the Office
Graphic Filters installed. Here is the A2K version: A2KLoadJpegGif. zip

NEW - April 05 2003 Ver 5.0 Developed to allow Access RunTime
installations to display Jpeg files in a standard Image Control.
Provides functionality to load JPG,GIF,BMP,EMF ,WMF,CUR and ICO files on
systems without the Office Graphics Filters loaded.
Originally developed for Systems with Access Runtime only. Supports
transparency in Transparent Gifs. Allows you to resize Images on
Forms/Reports at runtime with no loss of Image quality.

FInally take a moment to read the Image FAQ on my site here:
http://www.lebans.com/image_faq.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Dalan" <ot***@safe-mail.net> wrote in message
news:50******** *************** ***@posting.goo gle.com...
At first I was not certain what could cause Access 97 from displaying
most jpeg images, but not all. After further testing, it seemed that
all original images of less than 275 pixels per inch or less would
display, but those close to 300 pixels/inch or greater would not (MS
Access cannot recognize the file format xxx.jpg). The larger, original
images were scanned and saved as .bmp (at 300 dpi producing a 15MB
file). Then the images were saved as .jpg's around 1MB, and adjusted
downward, but no luck. However, MS Photo Editor would open the larger
jpeg file size images consistently.

Is this strange behavior or what? Has anyone experience this problem?
Any insight and tips will be appreciated. Thanks.


Thanks Larry and Steve for your suggestions. I am using a Windows 98
SE machine. Any and all BMP's that I have attempted to display in
Access have been extremely poor quality although the source images
were sharp. I'm just using small pieces of code for displaying as an
"Image", browse for file, and linked only and with photo path shown -
all independent of Access' built-in features for image display. What I
have discovered though is conflicting to what I have read regarding
the Runtime version needing supplemental graphic filters to display.
I have installed my Runtime version in tests on several machines with
different OS' a couple with different versions of MS Office (Access)
and a few with no MS Office installed at all. On every machine the
standard test jpeg images were displayed properly - how can this be?
My assumption has been that if other photo imaging software is
installed then the image display has been through utilization of
non-MS graphic filters - is this possible?

I will take another look at your LoadJpegGif solution Steve to see if
I can incorporate a workaround for the larger images. Thanks.
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

36
3470
by: Dmitriy Iassenev | last post by:
hi, I found an interesting thing in operator behaviour in C++ : int i=1; printf("%d",i++ + i++); I think the value of the expression "i++ + i++" _must_ be 3, but all the compilers I tested print 2.
6
3885
by: vad | last post by:
Hi! I am new to asp and here is my question. I have an MS Access datacase,In one table I stored all the information regarding one truck, including 4 images for each of the truck.The data type for images are OLEObject. I am sending the information into the table using MS Access Form.and the images using insert object.Now the problem is they are not displaying on an ASP form, but the text is displaying ok.Any help!
3
4079
by: Bob Dydd | last post by:
Hi Everybody I have an Access 2000 db with a setup for inserting images in records. I am using the image path only with the actual images stored elswhere on the hard disc. This works perfectly well with all of Microsoft developer installed on the system. The problem is when I give this to a user who has NOT got Access 2000, ie I just give him an installation that installs a runtime, my frontend/backend and images, an error says that...
1
2969
by: Ezra | last post by:
Our company's web server is trying to access graphics files on another server. When I run the app from Visual Studio (1.0) on my localhost, the server in question is available (which is accessed a virtual directory) and I'm able to display the files. However, when we logon to the intranet through a browser, and click the link which will display the files, we get the "Enter Network Password" logon box. We set the proper permissions on...
1
3121
by: gm | last post by:
Hi; I have written a database that tracks all the installation we have ever done. I have a small heating company. I have recently started keeping a directory of digital photographs of the completed job. I can create a hyperlink button that will link to a photgraph, but I cannot link to a specific photo of that specific job. Each job has its' own unique identifier, I call it the GOTC number. It is a separate field in the table of installed...
7
10180
by: needin4mation | last post by:
Hi, I have an Access 2002 - 2003 database. I am using Access 2003. Whenever I link an image all it shows is the filename. Not the image. Other versions of Access can link the image just fine. The properties look the same whether I use XP or 2003 versions of Office. If I take an earlier version of Access and link the image, it puts the image. I can also see the image in 2003. If I link the image using 2003 it only shows the filename....
3
1252
by: simchajoy2000 | last post by:
Hi, I am using a datagrid which contains a dataset with several tables and I am experiencing an inexplicable behavior that I am unable to resolve. Perhaps it's due to the complexity of my scenario which I will briefly describe here just in case it is a factor: I am querying an Access database and displaying the results in a Datagrid - then the user can perform additional queries based on the displayed Access information and I then...
3
2434
by: senfo | last post by:
I developed a Windows control in VS 2005 that inherits from the PictureBox Control that adds the ability to select images in a Windows application. It is, however, experiencing a strange issue that I can't explain. One of the desired affects was to provide the ability to change the background color on images that were selected, as well as setting the background color back to its original color after the image had been deselected. To...
4
2688
by: redpears007 | last post by:
Hi Again, Throwing this one out to you again as i am not getting anywhere and can find little to no information out there. I am currently displaying images (Jpegs) in access via the routine set up in the article http://support.microsoft.com/kb/285820/en-us. It works fine if the image is under 1000x1000 pixels. It is set up so the user can double click to open the image in its host application.
0
9927
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11098
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10814
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9552
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7109
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5977
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4597
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4196
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3223
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.