another newboe mxodbc quest. -- update set

[Nicole Cook]

I'm running python 1.5.2 on windows98 and using mxODBC to talk to an Access
database.   I'm having no trouble reading information from the database, but
now I want to write something to a column.

So I do :
db = ODBC.Windoes.connect("accessdb")
cs = db.cursor()

cs.execute("UPDATE Project SET Item='"+item+"' WHERE Name='"+name+"'")

When I do this from  the interpreter it returns 1, when I use it as a line
in a function Access freezes until I quit python.  Either way, nothing
happens to the column in the db that I'm trying to write.  Is there
something else I have to do to get mxODBC to execute an update?

Nicole