Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • 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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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