Solved

Problem assigning associated OLE Field

Posted on 2001-06-13
4
231 Views
Last Modified: 2012-05-04
When I try to associate a image picture to an associated OLE field I receive an error like "OLE SERVER NOT REGISTERED". I tried to reinstall Access and it works for some time, but then still the same problem; I suppose when I install or remove other application the problem come back. Anyway, I have no idea about this error, it should not occur since I'm working with BMP image.

OLEIMAGE.Class = "Paint.Picture"
OLEIMAGE.OLETypeAllowed = acOLELinked
OLEIMAGE.SourceDoc = Preview.Picture
' Create linked object.
OLEIMAGE.Action = acOLECreateLink 'here the error occurs
0
Comment
Question by:gianluca
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 4

Accepted Solution

by:
nmilmine earned 200 total points
ID: 6189126
Hi gianluca

Have you checked for missing refernces

1. Select the modules tab
2. Select New Module
3. Select Tools References
See if you have a link to reference OLE Automation
If not select it from the list and see if this helps

Neil
0
 

Author Comment

by:gianluca
ID: 6192693
I followed your indication and I add the "OLE Automation" reference. Now when I try to copy the image I receive the runtime-error 3163. If I use the copy / paste function from command menu it works perfectly.
0
 

Author Comment

by:gianluca
ID: 6196392
I added the "OLE Automation" reference in the module I have, and the error is changed : now it reports run-time error 3163.
0
 

Author Comment

by:gianluca
ID: 6196467
I solved the run-time error 3163 with the follwing code :

  OLEIMAGE.OLETypeAllowed = 1
  OLEIMAGE.SourceDoc = Preview.Picture
  OLEIMAGE.Action = 0

it was problably inverted the OLETypeAllowed value with the Action value
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question