Solved

Problem assigning associated OLE Field

Posted on 2001-06-13
4
225 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
  • 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now