Acc 2007 and OLE Object Error

[Brian17]

Hi all, been looking at lots of possible fixes for this issue, but can't
pinpoint it yet.

In an acc 2007 table, inserted a bmp into a field that is currently set to
store OLE objects. When in the dialog box browsing to find the image, once it
is found and I double click it to insert it, I get the error:

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

I tried some of the solutions I found that were related to earlier versions
of Access, but nothing works. I can insert the same bmp into a Word 2007
document without issue.

I know this is not the best way to insert images, but this is for a college
class and the instructor is following the examples provided in the text. The
students are seeing this error when they try it.

Anyone have any thoughts on this? I've been stumpted for some time on this.
Thanks!
-Brian

 

[Guest]

Hi all, been looking at lots of possible fixes for this issue, but can't
pinpoint it yet.

In an acc 2007 table, inserted a bmp into a field that is currently set to
store OLE objects. When in the dialog box browsing to find the image, once
it
is found and I double click it to insert it, I get the error:

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

I tried some of the solutions I found that were related to earlier
versions
of Access, but nothing works. I can insert the same bmp into a Word 2007
document without issue.

I know this is not the best way to insert images, but this is for a
college
class and the instructor is following the examples provided in the text.
The
students are seeing this error when they try it.

Anyone have any thoughts on this? I've been stumpted for some time on
this.
Thanks!
-Brian

 

[Stephen Lebans]

A couple of things to try:

1) Turn off your AntiVirus software. Norton in particular can cause the
issue as described.

2) Convert theBMP to JPG or PNG. Try inserting. What happens?

Finally, from your Explorer Window, double click on any Bitmap file. What
application opens up to display the BMP?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Brian17]

Hi, thanks for the suggestions.

1) Tried with McAfee on and off, same results.
2) We converted the bmp to jpg and inserted it, same results. Tried a
different bmp, different database, etc. (all the combinations) and same
result.
3) When I double click the bmp on the windows desktop it launched in windows
picture/fax viewer. Changed the association of the bmp to paint and other
photo editing programs and same result.

Now, this is happening in a college campus computer lab and only to some
machines. I tried 2 machines side by side in the room and it works fine in
one and not the other. Using the same database and test bmp file. I am
leaning towards something being different with the installs of office,
although both are complete installs of Office 07. Both machines also have
Project and Visio 2003 installed and the file size of each installed programs
is different on the machines. It works in the half the room and not the other
half.

Thanks for your thoughts, anything else you think of please reply.
-Brian

 

[Stephen Lebans]

MS Paint must be registered as the app to handle BMP files, not the WIndows
Picture/Fax viewer. I have seen cases in the NG's where MS Paint was the app
registered for BMP files but NOT as the OLE Server for BMP files.
Here is a thread on this topic. WHile it refers to MS Office Photo Editor
the logic is what you need to follow for MS Paint. Watch our for NG
linewrapping!

http://groups.google.ca/group/micro...en&lnk=st&q=lebans+paint+bob#7cc573b7d86e58c9

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Brian17]

Thanks Stephen, I will try out the steps listed at the link and will report
back.
-Brian