[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