[AccessD] Access output to Excel

Lembit Soobik lembit.dbamail at t-online.de
Sat Sep 23 12:34:38 CDT 2006


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
>
> 




More information about the AccessD mailing list