[AccessD] Access and Excel issue

Gustav Brock Gustav at cactus.dk
Fri Mar 3 04:21:20 CST 2006


Hi Rocky

You can still link and reading is possible but update and append will be disabled.

/gustav

>>> jwcolby at ColbyConsulting.com 03-03-2006 05:18 >>>
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&zoneid=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




More information about the AccessD mailing list