A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

OLE Object Data Type Question



 
 
Thread Tools Display Modes
  #1  
Old February 7th, 2010, 06:06 PM posted to microsoft.public.access
Anatoly Kurilin
external usenet poster
 
Posts: 21
Default OLE Object Data Type Question

Hi, a friend of mine supports a very simple Access 2000 database for keeping
tracks of his .JPG file. The database has a table with several field, and
one of them is of OLE Object data typy. He opens that table, rightclicks OLE
Object field, selects Insert Oject and creates a link to a .JPG file. After
finishing insertion the OLE Object field contains kind of "MSPicture3" or
"MSImage3" (I don't remember exactly the text).
Before a month ago he moved his database to another computer and now after
insertion into the OLE Object field a link, it contains "Packet" text and
the form which shows the pictures does not work properly. Why the text of
that OLE Object changed and is it possible to restore the former text in
that field.

Thank in advance,
AK


  #2  
Old February 7th, 2010, 06:53 PM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default OLE Object Data Type Question

The probable cause is that the new computer doesn't have an OLE server, or
the OLE isn't registered for JPG file types. MS-Paint is an OLE server, Try
associating JPGs with MS-Paint, and rebooting the machine. If should work
properly.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Hi, a friend of mine supports a very simple Access 2000 database for
keeping tracks of his .JPG file. The database has a table with several
field, and one of them is of OLE Object data typy. He opens that table,
rightclicks OLE Object field, selects Insert Oject and creates a link to a
.JPG file. After finishing insertion the OLE Object field contains kind of
"MSPicture3" or "MSImage3" (I don't remember exactly the text).
Before a month ago he moved his database to another computer and now after
insertion into the OLE Object field a link, it contains "Packet" text and
the form which shows the pictures does not work properly. Why the text of
that OLE Object changed and is it possible to restore the former text in
that field.

Thank in advance,
AK




  #3  
Old February 7th, 2010, 07:34 PM posted to microsoft.public.access
Anatoly Kurilin
external usenet poster
 
Posts: 21
Default OLE Object Data Type Question

Dear Arvin, thank you very much for the tip but please tell how to register
OLE for JPG file types.

"Arvin Meyer [MVP]" wrote in message
...
The probable cause is that the new computer doesn't have an OLE server, or
the OLE isn't registered for JPG file types. MS-Paint is an OLE server,
Try associating JPGs with MS-Paint, and rebooting the machine. If should
work properly.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Hi, a friend of mine supports a very simple Access 2000 database for
keeping tracks of his .JPG file. The database has a table with several
field, and one of them is of OLE Object data typy. He opens that table,
rightclicks OLE Object field, selects Insert Oject and creates a link to
a .JPG file. After finishing insertion the OLE Object field contains kind
of "MSPicture3" or "MSImage3" (I don't remember exactly the text).
Before a month ago he moved his database to another computer and now
after insertion into the OLE Object field a link, it contains "Packet"
text and the form which shows the pictures does not work properly. Why
the text of that OLE Object changed and is it possible to restore the
former text in that field.

Thank in advance,
AK






  #4  
Old February 7th, 2010, 08:06 PM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default OLE Object Data Type Question

It depends upon your operating system. On XP, open Windows Explorer (My
Computer) go to:

Tools Folder Options File Types

Scroll down to JPG and change the file type to Paint.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Dear Arvin, thank you very much for the tip but please tell how to
register OLE for JPG file types.

"Arvin Meyer [MVP]" wrote in message
...
The probable cause is that the new computer doesn't have an OLE server,
or the OLE isn't registered for JPG file types. MS-Paint is an OLE
server, Try associating JPGs with MS-Paint, and rebooting the machine. If
should work properly.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Hi, a friend of mine supports a very simple Access 2000 database for
keeping tracks of his .JPG file. The database has a table with several
field, and one of them is of OLE Object data typy. He opens that table,
rightclicks OLE Object field, selects Insert Oject and creates a link to
a .JPG file. After finishing insertion the OLE Object field contains
kind of "MSPicture3" or "MSImage3" (I don't remember exactly the text).
Before a month ago he moved his database to another computer and now
after insertion into the OLE Object field a link, it contains "Packet"
text and the form which shows the pictures does not work properly. Why
the text of that OLE Object changed and is it possible to restore the
former text in that field.

Thank in advance,
AK








  #5  
Old February 7th, 2010, 09:22 PM posted to microsoft.public.access
Anatoly Kurilin
external usenet poster
 
Posts: 21
Default OLE Object Data Type Question

Thank you, Arvin, I followed your instruntions and now the file types .JPG
and JPEG open with Window Paint but nonetheless links to these files
continue to instert as Package.

"Arvin Meyer [MVP]" wrote in message
...
It depends upon your operating system. On XP, open Windows Explorer (My
Computer) go to:

Tools Folder Options File Types

Scroll down to JPG and change the file type to Paint.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Dear Arvin, thank you very much for the tip but please tell how to
register OLE for JPG file types.

"Arvin Meyer [MVP]" wrote in message
...
The probable cause is that the new computer doesn't have an OLE server,
or the OLE isn't registered for JPG file types. MS-Paint is an OLE
server, Try associating JPGs with MS-Paint, and rebooting the machine.
If should work properly.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Hi, a friend of mine supports a very simple Access 2000 database for
keeping tracks of his .JPG file. The database has a table with several
field, and one of them is of OLE Object data typy. He opens that table,
rightclicks OLE Object field, selects Insert Oject and creates a link
to a .JPG file. After finishing insertion the OLE Object field contains
kind of "MSPicture3" or "MSImage3" (I don't remember exactly the text).
Before a month ago he moved his database to another computer and now
after insertion into the OLE Object field a link, it contains "Packet"
text and the form which shows the pictures does not work properly. Why
the text of that OLE Object changed and is it possible to restore the
former text in that field.

Thank in advance,
AK










  #6  
Old February 8th, 2010, 02:50 AM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default OLE Object Data Type Question

Perhaps there is an embedded memory to the earlier file. Try adding some new
ones. Will they open properly?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Thank you, Arvin, I followed your instruntions and now the file types .JPG
and JPEG open with Window Paint but nonetheless links to these files
continue to instert as Package.

"Arvin Meyer [MVP]" wrote in message
...
It depends upon your operating system. On XP, open Windows Explorer (My
Computer) go to:

Tools Folder Options File Types

Scroll down to JPG and change the file type to Paint.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Dear Arvin, thank you very much for the tip but please tell how to
register OLE for JPG file types.

"Arvin Meyer [MVP]" wrote in message
...
The probable cause is that the new computer doesn't have an OLE server,
or the OLE isn't registered for JPG file types. MS-Paint is an OLE
server, Try associating JPGs with MS-Paint, and rebooting the machine.
If should work properly.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Hi, a friend of mine supports a very simple Access 2000 database for
keeping tracks of his .JPG file. The database has a table with several
field, and one of them is of OLE Object data typy. He opens that
table, rightclicks OLE Object field, selects Insert Oject and creates
a link to a .JPG file. After finishing insertion the OLE Object field
contains kind of "MSPicture3" or "MSImage3" (I don't remember exactly
the text).
Before a month ago he moved his database to another computer and now
after insertion into the OLE Object field a link, it contains "Packet"
text and the form which shows the pictures does not work properly. Why
the text of that OLE Object changed and is it possible to restore the
former text in that field.

Thank in advance,
AK












  #7  
Old February 8th, 2010, 06:50 AM posted to microsoft.public.access
Anatoly Kurilin
external usenet poster
 
Posts: 21
Default OLE Object Data Type Question

No they do not open properly. I even created a new OLE Object field but of
no avail.

"Arvin Meyer [MVP]" wrote in message
...
Perhaps there is an embedded memory to the earlier file. Try adding some
new ones. Will they open properly?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Thank you, Arvin, I followed your instruntions and now the file types
.JPG and JPEG open with Window Paint but nonetheless links to these files
continue to instert as Package.

"Arvin Meyer [MVP]" wrote in message
...
It depends upon your operating system. On XP, open Windows Explorer (My
Computer) go to:

Tools Folder Options File Types

Scroll down to JPG and change the file type to Paint.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Dear Arvin, thank you very much for the tip but please tell how to
register OLE for JPG file types.

"Arvin Meyer [MVP]" wrote in message
...
The probable cause is that the new computer doesn't have an OLE
server, or the OLE isn't registered for JPG file types. MS-Paint is an
OLE server, Try associating JPGs with MS-Paint, and rebooting the
machine. If should work properly.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Hi, a friend of mine supports a very simple Access 2000 database for
keeping tracks of his .JPG file. The database has a table with
several field, and one of them is of OLE Object data typy. He opens
that table, rightclicks OLE Object field, selects Insert Oject and
creates a link to a .JPG file. After finishing insertion the OLE
Object field contains kind of "MSPicture3" or "MSImage3" (I don't
remember exactly the text).
Before a month ago he moved his database to another computer and now
after insertion into the OLE Object field a link, it contains
"Packet" text and the form which shows the pictures does not work
properly. Why the text of that OLE Object changed and is it possible
to restore the former text in that field.

Thank in advance,
AK














  #8  
Old February 8th, 2010, 01:21 PM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default OLE Object Data Type Question

By any chance is there a different version of Office, or Access, on the new
computer? If so, there is a conversion pack for files that don't come
supported with the newer versions of Office.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
No they do not open properly. I even created a new OLE Object field but of
no avail.

"Arvin Meyer [MVP]" wrote in message
...
Perhaps there is an embedded memory to the earlier file. Try adding some
new ones. Will they open properly?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Thank you, Arvin, I followed your instruntions and now the file types
.JPG and JPEG open with Window Paint but nonetheless links to these
files continue to instert as Package.

"Arvin Meyer [MVP]" wrote in message
...
It depends upon your operating system. On XP, open Windows Explorer (My
Computer) go to:

Tools Folder Options File Types

Scroll down to JPG and change the file type to Paint.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Dear Arvin, thank you very much for the tip but please tell how to
register OLE for JPG file types.

"Arvin Meyer [MVP]" wrote in message
...
The probable cause is that the new computer doesn't have an OLE
server, or the OLE isn't registered for JPG file types. MS-Paint is
an OLE server, Try associating JPGs with MS-Paint, and rebooting the
machine. If should work properly.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Hi, a friend of mine supports a very simple Access 2000 database for
keeping tracks of his .JPG file. The database has a table with
several field, and one of them is of OLE Object data typy. He opens
that table, rightclicks OLE Object field, selects Insert Oject and
creates a link to a .JPG file. After finishing insertion the OLE
Object field contains kind of "MSPicture3" or "MSImage3" (I don't
remember exactly the text).
Before a month ago he moved his database to another computer and now
after insertion into the OLE Object field a link, it contains
"Packet" text and the form which shows the pictures does not work
properly. Why the text of that OLE Object changed and is it possible
to restore the former text in that field.

Thank in advance,
AK
















  #9  
Old February 9th, 2010, 06:44 AM posted to microsoft.public.access
Anatoly Kurilin
external usenet poster
 
Posts: 21
Default OLE Object Data Type Question

I've experimented on several computers using Access 2000 and XP but the
results were the same - "Package".

"Arvin Meyer [MVP]" wrote in message
...
By any chance is there a different version of Office, or Access, on the
new computer? If so, there is a conversion pack for files that don't come
supported with the newer versions of Office.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
No they do not open properly. I even created a new OLE Object field but
of no avail.

"Arvin Meyer [MVP]" wrote in message
...
Perhaps there is an embedded memory to the earlier file. Try adding some
new ones. Will they open properly?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Thank you, Arvin, I followed your instruntions and now the file types
.JPG and JPEG open with Window Paint but nonetheless links to these
files continue to instert as Package.

"Arvin Meyer [MVP]" wrote in message
...
It depends upon your operating system. On XP, open Windows Explorer
(My Computer) go to:

Tools Folder Options File Types

Scroll down to JPG and change the file type to Paint.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Dear Arvin, thank you very much for the tip but please tell how to
register OLE for JPG file types.

"Arvin Meyer [MVP]" wrote in message
...
The probable cause is that the new computer doesn't have an OLE
server, or the OLE isn't registered for JPG file types. MS-Paint is
an OLE server, Try associating JPGs with MS-Paint, and rebooting the
machine. If should work properly.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Anatoly Kurilin" wrote in message
...
Hi, a friend of mine supports a very simple Access 2000 database
for keeping tracks of his .JPG file. The database has a table with
several field, and one of them is of OLE Object data typy. He opens
that table, rightclicks OLE Object field, selects Insert Oject and
creates a link to a .JPG file. After finishing insertion the OLE
Object field contains kind of "MSPicture3" or "MSImage3" (I don't
remember exactly the text).
Before a month ago he moved his database to another computer and
now after insertion into the OLE Object field a link, it contains
"Packet" text and the form which shows the pictures does not work
properly. Why the text of that OLE Object changed and is it
possible to restore the former text in that field.

Thank in advance,
AK


















 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.