473,898 Members | 2,667 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 3488
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
3471
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
3886
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
4081
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
3122
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
10184
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
1253
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
2435
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
9841
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11265
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
10949
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
10484
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
8036
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7187
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
6077
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4296
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3306
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.