[thelist] Update on "Update Query not running"

[Michele Foster]

Scott,

I'm probably way off base .. and I've only been following the conversation
briefly..

I just pulled up an Access project of mine .. and I notice that when I use
the GUID field, it is NOT the primary key.  Here's the SQL I'm using, and it
works just fine.

sql = "update OrderNum set OrderComplete=True where SID='" & request("SID")
& "'"

I can't remember why I didn't set that particular field to be the primary
key .. well, actually I can .. but that would take me too long to explain.
;)

I'd try what Chris just suggested .. running it through the query analyzer
itself.  Or just create a new query and C&P the code from the query view and
drop it into your ASP.

Mich

----- Original Message -----
From: "Scott Brady" <dsbrady at scottbrady.net>


| 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.
|