[AccessD] Access and Excel issue

John Colby jwcolby at ColbyConsulting.com
Thu Mar 2 23:16:59 CST 2006


No, in AXP (2002) but service packs updated AXP (and maybe even before) and
above to prevent links from working.

John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Thursday, March 02, 2006 11:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access and Excel issue

In A2K3 SP2?

Rocky


John Colby wrote:
> I think the issue is specifically that linking spreadsheets has been 
> disabled.  If you use automation then you don't have an issue.  IO 
> know that because I am using automation (successfully) myself.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky 
> Smolin - Beach Access Software
> Sent: Thursday, March 02, 2006 7:43 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access and Excel issue
>
> Dear List:
>
> According to this:
>
> http://winks.office-watch.com/9/templates/feat.aspx?articleid=7&zoneid
> =2 
> <http://winks.office-watch.com/9/templates/feat.aspx?articleid=7&zonei
> d=2>
>
> Some of the functionality between Access and Excel is disabled in 2002 
> and
> 2003 SP2.
>
>
> I have a client where I create a rather elaborate worksheet from a 
> template in Access and push data out to the Excel worksheet, then open 
> it up for editing.  When the worksheet is saved, I have a lot of code 
> behind the worksheet that pushes the data back into the Access tables.
> The worksheets are not linked however.  I use automation to do the 
> data transfers.  Am I in trouble here or did I inadvertently dodge 
> this bullet?  The article refers to linked tables and spreadsheets.
>
> TIA
>
> Rocky
>
>
>   

--
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

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




More information about the AccessD mailing list