Error Message: The OLe Server Isn't registered.

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

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


--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener" wrote in message
...
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:

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
-----Original Message-----
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


--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener"
wrote in message
...
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


.

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.

--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener" wrote in message
...
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
-----Original Message-----
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


--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener"
wrote in message
...
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:

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
-----Original Message-----
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.

--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener"
wrote in message
...
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
-----Original Message-----
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


--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener"
wrote in message
...
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


.



.

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....nceErrors.html

-----

I apologize that I don't have more suggestions for you at this time.

--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Don Regener" wrote in message
...
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
-----Original Message-----
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.

--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener"
wrote in message
...
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
-----Original Message-----
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


--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener"
wrote in message
...
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:

Let me check some of these suggestions out.

Appreciate your help.

Don
-----Original Message-----
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....ccessReference
Errors.html

-----

I apologize that I don't have more suggestions for you at
this time.

--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Don Regener" wrote
in message
...
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
-----Original Message-----
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.

--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener"
wrote in message
...
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
-----Original Message-----
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


--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Donald Regener"

wrote in message
...
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


.



.



.