[AccessD] Access output to Excel

Lembit

...afaik, the patch was applied only to XP/2002 products and forward ...your 
problem may be in using the Excel 2k3 rather than the A2K itself ...if you 
can remove the SP2 office 2K3 patch, you may find that the linking will work 
again ...but then of course MS will insist you upgrade it again :(

...the guy wrote a brief description of how to link a spreadsheet back in 
'90 and got a patent on it ...MS claims it was working on the methodology 
before they were contacted by him in '92 ...he wanted $500 mil and $2 on 
every future MS sale ...MS said no ...the court gave him $8.7 mil and 
ordered MS to remove the functionality from all future products.

...MS was supposedly working on a verified clean room developed replacement 
...why that would take so long is a mystery.

William Hindman

----- Original Message ----- 
From: "Lembit Soobik" <lembit.dbamail at t-online.de>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, September 23, 2006 1:34 PM
Subject: Re: [AccessD] Access output to Excel


oh, what a §%!"§"/§/%!

thank you, Marty, for the fast relply and the links.

Do you know whether Access97 has the same problem?

thanks
Lembit

----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, September 23, 2006 7:13 PM
Subject: Re: [AccessD] Access output to Excel


> You have probably hit the Excel Access Link Patent infringement patch
> It was installed with a patch to Office XP or Office  2003 SP2, last may??
> I don't know if you can back out of this patch.
> See explanation :
> http://winks.office-watch.com/9/templates/feat.aspx?articleid=7&zoneid=2
>
> perhaps a workaround here to copy data back and forth via ADO
> what you cannot do now is see instant changes in the xls and mdb
> file simultaneously via links.
>
> http://office-watch.com/kb/?904953
>
> Lembit Soobik wrote:
>
>>I have an Excel worksheet (Excel 2002 SP3) with some named spaces.
>>In Access (A2000) I have these named spaces as linked tables.
>>I can read these tables (VB) as DAO.recordset just like any other table,
>>However I cannot write to these tables.
>>vb tells me its write protected.
>>the xls file is NOT write protected.
>>I have unprotected the worksheet.
>>
>>what else can be wrong?
>>
>>thanks
>>Lembit
>>
>>
>
> -- 
> Marty Connelly
> Victoria, B.C.
> Canada
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.405 / Virus Database: 268.12.8/455 - Release Date: 22.09.2006
>
>

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