J
Jim Lyon
I'm trying to update an Access 2000 table which has two
columns, "home" and "text". Here are the commands in my
script:
set DBObj = Server.CreateObject("ADODB.Connection")
DBObj.Open "MoFireDB"
SQL = "Update text_tab set text = 'test33' where name
= 'HOME' "
DBObj.execute(SQL)
DBObj.close
The above execute errors out with the following messages:
Microsoft OLE DB Provider for ODBC Drivers error 80040e14
[ODBC Microsoft Access Driver] Syntax error in UPDATE
Trying to do an insert gives me similar messages.
However, if I change SQL to:
"Delete from text_tab where name = 'HOME' "
then the code works fine.
If the syntax of the Update is wrong, I don't see it.
So, select and delete work, while update and insert don't.
Can anyone tell me what's wrong and how to fix it?
Many thanks.
columns, "home" and "text". Here are the commands in my
script:
set DBObj = Server.CreateObject("ADODB.Connection")
DBObj.Open "MoFireDB"
SQL = "Update text_tab set text = 'test33' where name
= 'HOME' "
DBObj.execute(SQL)
DBObj.close
The above execute errors out with the following messages:
Microsoft OLE DB Provider for ODBC Drivers error 80040e14
[ODBC Microsoft Access Driver] Syntax error in UPDATE
Trying to do an insert gives me similar messages.
However, if I change SQL to:
"Delete from text_tab where name = 'HOME' "
then the code works fine.
If the syntax of the Update is wrong, I don't see it.
So, select and delete work, while update and insert don't.
Can anyone tell me what's wrong and how to fix it?
Many thanks.