Environment:
NT 4.0, IIS 4, PHP 4.1.1, UltraDev 4, PHAkt 1.1.1, aodbc 1.54
Access database configured as system DSN, no sql server

PHAkt is working great to generate php code to query my
.mdb files and display records.

But when I use the "Update record" server behavior or Live Object,
the generated php code produces the error:

[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

Has anyone seen this syndrome? Any hints for settings I could
change to even get a more descriptive error message would be
most appreciated.

In php.ini I have:
register_globals = On
magic_quotes_gpc = On
magic_quotes_runtime = On
magic_quotes_sybase = Off

Ah-ha, problem-o solved, thanks to an earlier post by Tim Green in response
to a similar error message generated from an Insert Record form.

I had a column in my database table named TEXT. Changing the column
name to TXT made the error message go away. The Update Record server
behavior workee now!

Thank you, Tim Green!

You're very welcome! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>