If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem Inserting Images into Access
I just accessed to Access 2003 and still have the same problem. Any ideas? Do you mean upgraded ? Office 2003 uninstalls the application that you were probably using as an 'OLE Server' for JPEG images, i.e. MS Photo Editor. Alternatively, if you installed an application that 'took over' the file registration for .jpg then you would have the same problem. Open the table and check what is displayed in the relevant field to see which application you were using. You can usually fix this by reinstalling MS Photo Editor from the Office XP CD. Note, however, that this is just one of the drawbacks of OLE Embedding for image storage; others can include a huge storage overhead, typically between 20 and 200 *times* the original filesize for JPEG. Using OLE Embedding with images is not the way to future-proof your application. You'll find more about the disappearance of photo editor he "What happened to Photo Editor?" http://office.microsoft.com/en-us/as...454871033.aspx and he "Photo Editor is removed when you install Office 2003" http://support.microsoft.com/?kbid=817095 and info about the problems with OLE Embedding he "Pictures in Access Forms & Reports - OLE Object Photo & Image Problems & Solutions" http://www.ammara.com/articles/accesspictureole.html -- __________________________________________________ _____ http://www.ammara.com/ Image Handling Components, Samples, Solutions and Info DBPix 2.0: Add pictures to Access, Easily & Efficiently =?Utf-8?B?Q2hhcmxlc1Bob3Rv?= wrote: For months I have been successfully putting jpeg images (using Insert Object and selecting the file) into my Access 2000 database. All of a sudden when I tried to do that I got the filename listed instead of the image. I thought it might be a size problem, so I made a greatly reduced copy of the database (with most images deleted) and I still get the same thing. Each jpeg image is about 25KB in size. Still thinking that it might be a memory problem, I just accessed to Access 2003 and still have the same problem. Any ideas? Charles |
#2
|
|||
|
|||
Problem Inserting Images into Access
I did mean upgrade. Thanks for the help. I've downloaded DBPix and will try
it out. Looks like OLEs are a deadend and more trouble than they're worth. I was wondering why my database was getting so big adding small pictures. Thanks again. Charles "bob" wrote: I just accessed to Access 2003 and still have the same problem. Any ideas? Do you mean upgraded ? Office 2003 uninstalls the application that you were probably using as an 'OLE Server' for JPEG images, i.e. MS Photo Editor. Alternatively, if you installed an application that 'took over' the file registration for .jpg then you would have the same problem. Open the table and check what is displayed in the relevant field to see which application you were using. You can usually fix this by reinstalling MS Photo Editor from the Office XP CD. Note, however, that this is just one of the drawbacks of OLE Embedding for image storage; others can include a huge storage overhead, typically between 20 and 200 *times* the original filesize for JPEG. Using OLE Embedding with images is not the way to future-proof your application. You'll find more about the disappearance of photo editor he "What happened to Photo Editor?" http://office.microsoft.com/en-us/as...454871033.aspx and he "Photo Editor is removed when you install Office 2003" http://support.microsoft.com/?kbid=817095 and info about the problems with OLE Embedding he "Pictures in Access Forms & Reports - OLE Object Photo & Image Problems & Solutions" http://www.ammara.com/articles/accesspictureole.html -- __________________________________________________ _____ http://www.ammara.com/ Image Handling Components, Samples, Solutions and Info DBPix 2.0: Add pictures to Access, Easily & Efficiently =?Utf-8?B?Q2hhcmxlc1Bob3Rv?= wrote: For months I have been successfully putting jpeg images (using Insert Object and selecting the file) into my Access 2000 database. All of a sudden when I tried to do that I got the filename listed instead of the image. I thought it might be a size problem, so I made a greatly reduced copy of the database (with most images deleted) and I still get the same thing. Each jpeg image is about 25KB in size. Still thinking that it might be a memory problem, I just accessed to Access 2003 and still have the same problem. Any ideas? Charles |
#3
|
|||
|
|||
Problem Inserting Images into Access
I've been trying to figure out this whole storing pictures as well Charles!
It seems that the most common response is to link them, that way all you are saving in your database is just a file path to the photo itself. Just have an unbound Image control and point it to the image path. For example, on a form you could have a hidden text box that contains the path D:\MyStuff\Pictures\Photo.jpg and with a little code your image control would display that picture! It kind of sounds simple, but im having a heck of a time working out all the kinks. Don't know if that will help or not, but it will save you a bunch of space! -Jeff |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting images in Access forms | Peter Benson | Using Forms | 1 | June 3rd, 2005 09:51 AM |
starting access 97 | Edward Letendre | General Discussion | 2 | January 26th, 2005 02:15 AM |
WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 01:03 PM |
Access 2002 Print Problem | Tom Developer | Setting Up & Running Reports | 0 | October 21st, 2004 10:51 PM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |