?
Solved

What is causing Microsoft Access ODBC Error - "Syntax error in update statement"?

Posted on 2014-07-14
6
Medium Priority
?
190 Views
Last Modified: 2014-07-14
I am not a programmer. I am using Dreamweaver to update (edit) a dynamic table on my website.
I cannot seem to figure out what is wrong with the code. Please see the attached Word document for the error message and the code that Dreamweaver filled in for me.  I hi-lited in yellow the line of code that the error message  refers to.

Any help in resolving this issue would be greatly appreciated.

Thank you...
Rick
ERROR-MESSAGE.doc
0
Comment
Question by:ES-Components
  • 3
  • 3
6 Comments
 
LVL 21

Accepted Solution

by:
Randy Poole earned 2000 total points
ID: 40194603
Add a Response.Write(MM_editQuery);
before the following line:
    MM_editCmd.Execute();

and let me know what the output is
0
 

Author Comment

by:ES-Components
ID: 40194676
Made the change - Got another error message. See attached word document for error message.
Hi-lited in blue is what it does not like.

Thank you...
Rick
ERROR-MESSAGE.doc
0
 
LVL 21

Expert Comment

by:Randy Poole
ID: 40194685
This error is normally caused by not having a valid selection in the drop down list, which would be prospect list in this error.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:ES-Components
ID: 40194712
I do not have any drop down lists. The name of my table that I am updating is called "ProspectList."
To update the table the client selects the line on the table to update and clicks the hyperlink.
The hyperlink passes the LineId to the update table page. (The code you are looking at).
Once the client types in the change on this page, they hit the submit button which is supposed to update the Access Table and then redirect the client back to the beginning page to see that the change was made.

Not sure if this will help you.

let me know.
thank you...
Rick
0
 

Author Closing Comment

by:ES-Components
ID: 40194839
Thank you very much for your help.
I figured out the second error. (The url address was incorrect) I made the change and the web page works fine.
Again thank you for the one line of code.

Rick
0
 
LVL 21

Expert Comment

by:Randy Poole
ID: 40194849
No problem
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question