Hale, Jim
Jim.Hale at FleetPride.com
Thu Oct 27 14:09:16 CDT 2005
Yea, I always pull linked data first into a mirror image Access table before doing any kind of manipulation. Has saved me many headaches over the years. Jim Hale -----Original Message----- From: John Colby [mailto:jwcolby at colbyconsulting.com] Sent: Thursday, October 27, 2005 2:00 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update query broke That was it. Now I am getting "updating data in a linked table not supported by this ISAM". The linked table is in the BE, and I have never seen this on before. Sigh. I guess I pull the queries into the BE and do it there. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim Sent: Thursday, October 27, 2005 2:20 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update query broke Look for spaces in front or behind of Address in the linked file. HTH Jim Hale -----Original Message----- From: John Colby [mailto:jwcolby at colbyconsulting.com] Sent: Thursday, October 27, 2005 1:14 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Update query broke I am trying to build an update query. I linked a text file, link that to tblMember on SSN, link that to another table tblFamily by PK/FK, pull out a field from the tblFamily and try to update it from data in a field in the linked text file. In the updateto area of the query I place [Address] which is the name of the address field in the linked text file. The query pops up a dialog asking for the value of [Address], as if there is no such address in the linked text file. I have only done this a million times before, but this time it doesn't work. Any suggestions short of random acts of violence? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email.