OLE Server Not Register, Reinstall

[Ken Coburn]

Until recently I had no problem inserting an OLE bound object (jpg image)
into an Access 2003 form but now I get a message stating that the "OLE Server
may not be registered. To register the OLE server, reinstall it"

I have spent hours search web site forums looking for an answer but none of
the suggestions that I have found (there are lots) have helped.

I have done all of the following to no avail:

Reinstalled Paint Shop Pro 5.1 (the registered program for the image file)
Uninstalled and reinstalled Access 2003 (SP3)
Repaired my Office install (Access Help and Repair... menu item)
Re-register triedit.dll as per Microsoft 'fix' for this problem.
Disabled AVG Antivirus (I do not have Norton which is cited as a problem)
Reassociated all .jpg files and derivatives to PSP 5.1

In other words, I have done everything that lots of other people have tried.
There is one comment on this site that Microsoft are aware of this problem
and, until they get round to doing a bug fix, a suggestion that it can be
fixed by uninstalling Office 2003 completely and reinstalling as far as SP2
(not installing SP3). I have not tried this yet because I used to be able to
insert an image in my Access form with SP3 installed.

Does anyone have any different advice that I have not tried before I
reinstall Office 2003 and only include SP2?

 

[Tom van Stiphout]

On Wed, 2 Apr 2008 06:41:00 -0700, Ken Coburn

Best practice is to NOT store images in the database, but in the file
system. I realize that would require some rework of your app, but one
of the reasons this advice is given is exactly the problem you find
yourself in now. OLE is a beautiful system, as long as it works.

-Tom.

 

[Ken Coburn]

Tom

Thanks for responding - but I am not sure what you mean. I have an Access
form which looks at a database of 100+ people and I want to show their
photographs (images) whan I select their Access record in Form view. How
does your advice not to use images in a database fit this situation?

 

[Tom van Stiphout]

On Wed, 2 Apr 2008 09:07:00 -0700, Ken Coburn

Often discussed in this newsgroup, so you should have no problem
finding other links.
Basically: you replace the OLE field with a text field. This field
stores the full or relative path to the images that are stored in the
file system on some server.
Most image controls can show an image when given the full path to it.

-Tom.

 

[Ken Coburn]

I am still having difficulty understanding what to do. I created a test
database, created a table with one text field and typed in the full path to
an image file on the first row. I then created a test form and tried to
relate the image field to the table but could not find a way to do that. The
properties box control source did not list the table. What am I doing wrong?