View Single Post
  #9  
Old February 9th, 2010, 05: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