• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Problem assigning associated OLE Field

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
gianluca
Asked:
gianluca
  • 3
1 Solution
 
nmilmineCommented:
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
 
gianlucaAuthor Commented:
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
 
gianlucaAuthor Commented:
I added the "OLE Automation" reference in the module I have, and the error is changed : now it reports run-time error 3163.
0
 
gianlucaAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now