Error Message: The OLe Server Isn't registered.

[Donald Regener]

I have a table that includes one OLE Object Field. I am
trying to store .BMP and .TIFF Files in those fields.

I do not change these files very often. I started adding
more files to fill some of these fields and started
running into a Problem.

(1) I would try a "Copy and Paste" Sequence on the .TIFF
file.
(2) Sometimes the file could not be pasted and I receive
the Error Message: The OLE Server isn't registered. To
register the OLE server, reinstall it.
(3) IF I was able to store the file it would say: Package
OR ImagingDocument. The Package entries would view as
the "Name of the File" vice the data I put in the file.
The ImagingDocument may show the image in Windows Picture
& Fax View OR give me the OLE Registration Error.

I would appreciate any ideas as "How to fix the
problem". I am using these files as graphics in a Access
Report.

I understanding this whole design has its problems. I
would like to convert the whole system over to where you
give the Picture Control a File Name that is external to
the data base. It would then display the file as part of
the picture control.

I have not seen an easy example of how to do this. My
best bet time wise now is to get the OLE Mode Working.

Appreciate any/all help.


Don

 

[Ken Snell]

Don't store the images in your table. ACCESS "bloats" badly when you do
this.

See The ACCESS Web for info on how to handle this situation:
http://www.mvps.org/access/forms/frm0030.htm

 

[Donald Regener]

Ken:

First I would like to thank you for your help. I will
review these articles in prep for changing the overall
design of how I handle the storage of these files.

In the meantime, I am faced with what I thinks ia a
Problem ... I get the error message cited in the title of
this message whenever I double click on the File Stored
in the OLE Field OR when I try to copy another file into
the field.

This only happens on one computer. I can do it on the
other 2 or 3 Computers that run the same program with no
problem.

I am using Access 2000 with at least SR-2. The culprit
computer is a WinXP Pro. The working computers are
Windows 2000 Servers.

I am just trying to "Cox" these design along for a little
more. I will then phase in an "Upgraded" Design as you
suggest.

Again,

I appreciate your help.


Don

 

[Ken Snell]

Chances are that the one PC is missing a Reference. On that PC, open the
ACCESS file, go to Visual Basic Editor, click Tools | References and see if
one is marked as "missing". That is the library/driver that is needed for
ACCESS to use that OLE object. You'll need to register that library / driver
in order for the program to work.

 

[Don Regener]

Ken:

I tried that yesterday ... before I posted the question.

I did not see one with "MISSING" ... Sort of wonder IF I
do not have one Listed that should have been.

Do you happen to know WHICH REFERENCE I should be using???


Thanks,

Don

 

[Ken Snell]

No, I don't know which specific library your PC is needing.

There are other steps that can be taken to check your references..sometimes,
you won't see the MISSING nomenclature even when one is missing.
---
From info posted By Douglas Steele, MVP:

Two common reasons.

The first is that you've used Date somewhere else in your database: a field
in a table, a control on a form, or something like that. Date is a reserved
word, and should never be used in anything you created in the database.

The other possibility is that your references are messed up.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Donald Regener]

Ken:

Let me check some of these suggestions out.

Appreciate your help.

Don