acOLECreateLinked with .tif in XP

  • Thread starter Thread starter Fly Girl
  • Start date Start date
F

Fly Girl

Access 2002/XP

I'm finding that linking a file to an OLE container in XP
causes Windows Picture and Fax Viewer to crash with
unfortunate regularity. Once crashed the Access app must
be closed in order for things to get sorted out. Until
that time it is impossible to link .tif objects.

The following code works well in Access 2K .mdb but causes
the OLE Server for .tif files in XP (Windows Picture & Fax
Viewer) to crash ~50% of the time:

With Me.oleLinked
.Enabled = True
.Locked = False
.OLETypeAllowed = acOLELinked
.SourceDoc = strLinkFilePath
.Action = acOLECreateLink
End With

In XP an error occurs when the SourceDoc is a .tif file on
the line ".Action = acOLECreateLink". Error = "#2753 A
problem occurred while MS Access was communicating with
the OLE Server or Active X control."

Note: the 'black box' MS Access path of using 'Insert
Object' off of the shortcut menu does work when
linking .tif files. Unfortunately it does not serve the
needs of my app.

Any suggestions?

Also: Is "Windows Picture and Fax Viewer" new and improved
in Office 2003? Specifically is it more stable and does it
support the 'print' verb?
 
Hi,

My suggestion is that we can try to install Microsoft Photo Editor and
associate tif file type with Microsoft Photo Editor.

Office XP: How to install Microsoft Photo Editor
===========================
1. Go to Control Panel->Add/Remove Program.
2. Select Microsoft Office XP, and click the change button.
3. Select Add or Remove Features, and click Next.
4. Click the plus sign next to Microsoft Office to expand Microsoft Office
tree.
5. Click the plus sign next to Office tools to expand the sub-tree.
6. Click the icon next to Microsoft Photo Editor and select Run from my
computer.
7. Click Update to install it.


Please feel free to let me know if you have any concerns or questions.




Sincerely,

Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <www.microsoft.com/security>

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Content-Class: urn:content-classes:message
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| Access 2002/XP
|
| I'm finding that linking a file to an OLE container in XP
| causes Windows Picture and Fax Viewer to crash with
| unfortunate regularity. Once crashed the Access app must
| be closed in order for things to get sorted out. Until
| that time it is impossible to link .tif objects.
|
| The following code works well in Access 2K .mdb but causes
| the OLE Server for .tif files in XP (Windows Picture & Fax
| Viewer) to crash ~50% of the time:
|
| With Me.oleLinked
| .Enabled = True
| .Locked = False
| .OLETypeAllowed = acOLELinked
| .SourceDoc = strLinkFilePath
| .Action = acOLECreateLink
| End With
|
| In XP an error occurs when the SourceDoc is a .tif file on
| the line ".Action = acOLECreateLink". Error = "#2753 A
| problem occurred while MS Access was communicating with
| the OLE Server or Active X control."
|
| Note: the 'black box' MS Access path of using 'Insert
| Object' off of the shortcut menu does work when
| linking .tif files. Unfortunately it does not serve the
| needs of my app.
|
| Any suggestions?
|
| Also: Is "Windows Picture and Fax Viewer" new and improved
| in Office 2003? Specifically is it more stable and does it
| support the 'print' verb?
|
 
When I last checked, MS Photo Editor couldn't handle mutli-
page .tif files. I have users making .tif attachments that
I know are more than 15 pages.

Currently I believe my best hope is to manage to get my
company to buy licenses Kodak's Imaging for Windows--or
discontinue this functionality in the application.

If you think of any other solutions, please let me know.
Also, is there any hope that MS will have a more
functional viewer app bundled with their OS any time soon?

Thanks!
 
Hi,

The issue doesn't occur with Microsoft Photo Editor? If so, it is confirmed
the issue is related to Windows Picture and Fax Viewer; your option to get
a powerful viewer for tif file is on the right track. We have a wish
program collecting customer's advice and it possibly will be applied to
next release, your idea of having a more functional viewer app bundled with
Operating System is a great idea, you would invite you submit the wish via:

http://register.microsoft.com/mswish/suggestion.asp

Please let me know if you have any concerns or questions.



Sincerely,

Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <www.microsoft.com/security>

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Content-Class: urn:content-classes:message
| From: "Fly Girl" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| When I last checked, MS Photo Editor couldn't handle mutli-
| page .tif files. I have users making .tif attachments that
| I know are more than 15 pages.
|
| Currently I believe my best hope is to manage to get my
| company to buy licenses Kodak's Imaging for Windows--or
| discontinue this functionality in the application.
|
| If you think of any other solutions, please let me know.
| Also, is there any hope that MS will have a more
| functional viewer app bundled with their OS any time soon?
|
| Thanks!
|
| >-----Original Message-----
| >Hi,
| >
| >My suggestion is that we can try to install Microsoft
| Photo Editor and
| >associate tif file type with Microsoft Photo Editor.
| >
| >Office XP: How to install Microsoft Photo Editor
| >===========================
| >1. Go to Control Panel->Add/Remove Program.
| >2. Select Microsoft Office XP, and click the change
| button.
| >3. Select Add or Remove Features, and click Next.
| >4. Click the plus sign next to Microsoft Office to expand
| Microsoft Office
| >tree.
| >5. Click the plus sign next to Office tools to expand the
| sub-tree.
| >6. Click the icon next to Microsoft Photo Editor and
| select Run from my
| >computer.
| >7. Click Update to install it.
| >
| >
| >Please feel free to let me know if you have any concerns
| or questions.
| >
| >
| >
| >
| >Sincerely,
| >
| >Alick Ye, MCSD
| >Product Support Services
| >Microsoft Corporation
| >Get Secure! - <www.microsoft.com/security>
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights.
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| X-Tomcat-NG: microsoft.public.access.formscoding
| >|
| >| Access 2002/XP
| >|
| >| I'm finding that linking a file to an OLE container in
| XP
| >| causes Windows Picture and Fax Viewer to crash with
| >| unfortunate regularity. Once crashed the Access app
| must
| >| be closed in order for things to get sorted out. Until
| >| that time it is impossible to link .tif objects.
| >|
| >| The following code works well in Access 2K .mdb but
| causes
| >| the OLE Server for .tif files in XP (Windows Picture &
| Fax
| >| Viewer) to crash ~50% of the time:
| >|
| >| With Me.oleLinked
| >| .Enabled = True
| >| .Locked = False
| >| .OLETypeAllowed = acOLELinked
| >| .SourceDoc = strLinkFilePath
| >| .Action = acOLECreateLink
| >| End With
| >|
| >| In XP an error occurs when the SourceDoc is a .tif file
| on
| >| the line ".Action = acOLECreateLink". Error = "#2753 A
| >| problem occurred while MS Access was communicating with
| >| the OLE Server or Active X control."
| >|
| >| Note: the 'black box' MS Access path of using 'Insert
| >| Object' off of the shortcut menu does work when
| >| linking .tif files. Unfortunately it does not serve the
| >| needs of my app.
| >|
| >| Any suggestions?
| >|
| >| Also: Is "Windows Picture and Fax Viewer" new and
| improved
| >| in Office 2003? Specifically is it more stable and does
| it
| >| support the 'print' verb?
| >|
| >
| >.
| >
|
 
To be clear: I have not actually tested this process with
MS Photo Editor since there is no purpose for me doing so.
I am opening multi-page .tif files and, while Photo Editor
may open them, it won't let me view/print anything beyond
the first page. I do know the process is bullet proof with
Kodak's Imaging for Windows. Therefore, I believe it is an
issue with Picture and Fax Viewer.

I will submit my wishes to the list. Thanks very much for
giving me the address.
 
Back
Top