[thelist] Update on "Update Query not running"

[Chris Blessing]

Scott-

Forgive me for jumping in so late, but are you doing this directly through
Access or through an external entity like an ASP page?  Have you tried
response.write'ing the query out and then doing it manually through the
query analyzer?

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Scott Brady
Sent: Tuesday, January 22, 2002 5:19 PM
To: thelist at lists.evolt.org
Subject: [thelist] Update on "Update Query not running"


Ok, I've got another query for running an update on a different table, using
the same value for "user_id" as a foreign key [meaning, it's defined as a
"text" field] in the WHERE clause, and that works fine.

Does anyone know if there's an issue in Access on running an update query
where the primary key is a GUID?  It's the only difference I can think of
between the tables.