PC Review


Reply
Thread Tools Rate Thread

Can't import OLE object into Access without getting an error mess

 
 
George
Guest
Posts: n/a
 
      17th Jan 2008
The operation on the OLE object failed. The OLE server may not be
registered. To register the OLE server, reinstall it.
 
Reply With Quote
 
 
 
 
NetworkTrade
Guest
Posts: n/a
 
      17th Jan 2008
am copying in stuff I saved when I ran across this problem....there is a page
on this at the microsoft support area but I can't find the url:
--
NTC

OLE Embedding uses the registered OLE Server application for the particular
file-type to store the object when you insert it. If you have different
registered OLE servers on the different machines you will get
different behaviour. This is one of the drawbacks of OLE Embedding (but by
no means the most serious).
Open the table and check what text is displayed in your OLE Object field
for one of the records that ‘works’.
This should help you to identify the OLE Server application that was used
to store the image. Make sure
that this application is installed and registered on the other machine (and
any others where you will user
the database).


Stephen Lebans:
This issue pops up daily here.
An application has to be registered to insert and then later display the
embedded Image. You have obviously installed an application that has taken
over the registration for JPG Image files. You need to change this back to
the previous application that was functioning correctly as an OLE Server for
JPG images.


Images that are stored in OLE object fields do not appear correctly
SYMPTOMS
When you store an image file in a table as an OLE object in Microsoft Office
Access 2003, and then you try to display the stored image by embedding or by
linking the image file in a form, a report, or a data access page, you may
not be able to view the image. Additionally, you may notice that the file
icon displays the file name instead of the image itself.
Back to the top
CAUSE
This problem occurs because Access 2003 cannot find the OLE Server that can
correctly interpret the OLE object header information.
Back to the top
WORKAROUND
To work around this problem, use one of the following methods:
Back to the top
Install Microsoft Photo Editor
You can install Photo Editor from the Microsoft Office XP CD-ROM.

Display the images from a folder
Instead of storing the images inside the table as OLE objects, you can store
the image file paths and the image names in the table and then display the
images by using an image control. When you use an image control inside a form
or a report, Access does not require the OLE Server to display the images in
the image control. For more information, click the following article number
to view the article in the Microsoft Knowledge Base:
285820 How to display images from a folder in a form, a report, or a data
access page
Back to the top
MORE INFORMATION
When you install Microsoft Office 2003, the Setup program removes all the
standard components from Office XP (such as Photo Editor) that you previously
had installed on your computer. As a result, Access 2003 cannot find the OLE
Server that can display an image file (such as a .jpg file or a .gif file),
and you cannot view the embedded graphic files or the linked graphic files.

"George" wrote:

> The operation on the OLE object failed. The OLE server may not be
> registered. To register the OLE server, reinstall it.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot import outlook message sinto Wmail, get the MAPI error mess seliga Windows Vista Mail 0 27th Oct 2009 05:36 PM
HELP! Can't get localhost to access website without Error 500 mess =?Utf-8?B?TGFycnkgUy4=?= Windows Vista Networking 5 7th Mar 2007 01:13 AM
Access Import Excel error - columns of object IIMEXGRID failed =?Utf-8?B?RGF2aWRDb3BwZXJmaWVsZA==?= Microsoft Access Getting Started 2 26th Jun 2006 07:07 PM
error mess access heidi Microsoft Access 1 15th Oct 2003 12:16 AM
access 97 error mess on XP machine news.verizon.net Windows XP General 2 22nd Jul 2003 09:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:46 AM.