[AccessD] Update query broke

Try putting the name of the linked text file before the address
Like  TEXTFLE.ADDRESS
Or  [TEXTFILE].[ADDRESS]

Patti

******************************************************************
*Patricia O'Connor
*Associate Computer Programmer Analyst
*OTDA - BDMA
*(W) mailto:Patricia.O'Connor at otda.state.ny.us
*(w) mailto:aa1160 at otda.state.ny.us
******************************************************************
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
> Sent: Thursday, October 27, 2005 02: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
>