[AccessD] Requirement to install certain updates...

Marty:

Upon further research it seems that most of the clients should be unaffected
as I use a different technique to access spreadsheets from Access... still
have not confirmed this yet but will take a wait and see attitude.

I did find a potential issue that may have caused a problem for a specific
client but found the following code, uncovered by Gary Robinson, resolving a
Word Mail Merge problem and I hope this may help someone else:
(http://www.vb123.com/toolshed/news/issue61.htm)

<quote>
... Copious searching and debugging revealed the problem to be here:

With  .ActiveDocument.MailMerge
  	.Destination = wdSendToNewDocument
  	.SuppressBlankLines = True
  	With 	.DataSource
    		.FirstRecord = wdDefaultFirstRecord
    		.LastRecord = wdDefaultLastRecord
  	End With
  	.Execute Pause:=False
End With

and the fix to be this:

With 	.ActiveDocument.MailMerge
  	.OpenDataSource Name:="c:\path to mdb", _
  		LinkToSource:=True, AddToRecentFiles:=False, _
  		Connection:="table certaward", _
  		SQLStatement:="SELECT * FROM `table or query`"
  	.Destination = wdSendToNewDocument
  	.SuppressBlankLines = True
  	With 	.DataSource
    		.FirstRecord = wdDefaultFirstRecord
    		.LastRecord = wdDefaultLastRecord
  	End With
  	.Execute Pause:=False
End With

I have experts exchange to thank for the solution....from this thread:

http://www.experts-exchange.com/Applications/MS_Office/Q_20629652.html
</quote>

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: January 30, 2006 3:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Requirement to install certain updates...

You could try here.
Also shows how certain remote queries become read only;
affected after latest Access XP and 2003 SP's applied
like
SELECT [Companies$].*, * FROM [Companies$] IN 'c:\tmp\excel_be.xls 
'[Excel 8.0;];

http://www.vb123.com/toolshed/news/issue61.htm


Jim Lawrence wrote:

>Jim:
>
>Wouldn't it be as simple as going to MS update site:
>http://www.microsoft.com/downloads/details.aspx?FamilyId=57E27A97-2DB6-4654
-
>9DB6-EC7D5B4DD867&displaylang=en
>
>The problem relates around MS losing the court battle around Access being
>able to access and post data to Excel. If you have code that interfaces
with
>Excel from Access the standard method it may be disable after installing
SP2
>or it may just replace the existing code with something else. I have not
>heard one way or the other though comments from MS suggest that the current
>methods will simply be disabled.
>
>http://news.com.com/Patent+spat+forces+businesses+to+upgrade+Office/2100-10
1
>4_3-6032870.html
>
>There may be work-arounds but they will not be officially released until
>Office12. 
>
>I for one will have a number of systems that will be affected but am not
>sure how or/and when. If anyone out there has ran across those issues, I
>would love to hear about them.
> 
>Jim
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim DeMarco
>Sent: January 30, 2006 11:26 AM
>To: AccessD (E-mail)
>Subject: [AccessD] Requirement to install certain updates...
>
>... for future deployments of select Microsoft Office products
>
>List,
>
>We just got this from M$ Licensing.  Has anyone seen this yet?
>
>=================================================
>Background: It was recently decided in a court of law that certain portions
>of code found in Microsoft Office Professional Edition 2003, Microsoft
>Office Access 2003, Microsoft Office XP Professional and Microsoft Access
>2002 infringe a third-party patent. As a result, Microsoft must make
>available a revised version of these products with the allegedly infringing
>code replaced.
>
>Action required: As a result of the above ruling, you are required to: 
>*	Install Microsoft Office 2003 Service Pack 2 (Office 2003 SP2) for
>all your future deployments of Office Professional Edition 2003 and Office
>Access 2003, 
>*	Install the Microsoft Office XP Service Pack 3 Patch (Office XP SP3
>Patch) for all your future deployments of Office XP Professional and Access
>2002
>Action requested: To keep your current systems in alignment with your
future
>deployments of these products, Microsoft is requesting that you also update
>all your current Office Professional Edition 2003 and Office Access 2003
>installations with Office 2003 SP2, and Office XP Professional and Access
>2002 installations with the Office XP SP3 Patch.
>
>How do I do this?: You can obtain both Office 2003 SP2 and the Office XP
SP3
>Patch by going to the website listed below and downloading it directly, or
>by contacting your reseller. 
>===================================================
>
>Jim DeMarco
>
>
>
>***************************************************************************
*
>*******
>"This electronic message is intended to be for the use only of the named
>recipient, and may contain information from Hudson Health Plan (HHP) that
is
>confidential or privileged.  If you are not the intended recipient, you are
>hereby notified that any disclosure, copying, distribution or use of the
>contents of this message is strictly prohibited.  If you have received this
>message in error or are not the named recipient, please notify us
>immediately, either by contacting the sender at the electronic mail address
>noted above or calling HHP at (914) 631-1611. If you are not the intended
>recipient, please do not forward this email to anyone, and delete and
>destroy all copies of this message.  Thank You".
>***************************************************************************
*
>*******
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com