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