[AccessD] Access output to Excel

Here are the patches that produce the behaviour
includes installs of Access 2003 runtimes.
You might get away with it by running Access 2000 or lower.

http://support.microsoft.com/?kbid=904953
I would suspect any patches to Access XP + after
this date, or runtime installs  and  install of access 2007
Knowledge Base (KB) Articles: KB904018 
Date Published: 10/18/2005

Tested it out with Access 2007 and Excel 2007
doesn't link if both programs open.
The version level of Excel is irrelevant, it is a
patch or version of Access that does it.

However you can link tables properly with Access 97
and Excel 2007, I suppose Access 2000 would work too.



Lembit Soobik wrote:

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

-- 
Marty Connelly
Victoria, B.C.
Canada