[AccessD] update wouldn't run

Hi Susan,

Your query may have tried to update a text 20 to a numeric 21, which would
have been the wrong type and should not have worked.

Just a guess ...

Dan

PS - Don't ever tell anyone you're an expert.  As soon as I said it - I
wasn't!  :-(

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, July 18, 2011 7:13 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] update wouldn't run

I ran into a really weird, and a bit humiliating situation this afternoon. I
volunteer at our county fair and someone asked me to help them update some
entry numbers in an Access table. It was a simple update query -- make all
20's 21. It was a text field. I created the query, ran it... it wouldn't
run. It did nothing. The text field was part of a natural key primary key,
but she was able to change the values manually. That query should've run and
changed all those values in a second -- fortunately, there were only a few
dozen, but I was still... deflated. :( 

Any ideas what might have been the problem? 

Susan H. 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com