huizhen
|
| Posted: 04/23/2002, 11:28 PM |
|
when i want to insert a new or update a existing record this error appears...but the delete function works properly.pls help
Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. (Microsoft OLE DB Provider for ODBC Drivers)
|
|
|
 |
Nicole
|
| Posted: 04/24/2002, 2:29 AM |
|
Hello,
Are you using custom SQL for the form or any other event code? Also, make sure that in the form, you have marked the correct primary key field and the field types of each of the fields is correct. You should also check to endure that you don't have two copies of the same input parameters.
Anyway you can print SQL and test it against db .
|
|
|
|
|
