Acc 2007 and OLE Object Error


B

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
 
Ad

Advertisements

G

Guest

Brian17 said:
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
 
S

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.
 
B

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
 
S

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.
 
Ad

Advertisements

B

Brian17

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top