Click here to Skip to main content
15,559,491 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi ,

iam not able to update memo field .could you please let me know whats the problem in access. its through syntax error.

UPDATE [Code] SET Test = "_hmHB1=#B0|_hmHI1=#B1|_hmHB2=#B0|_hmHI2=#B0|_hmVB1=#B1|_hmHB2DY=#M0" WHERE ID= 29

What I have tried:

UPDATE [Code] SET Test = "_hmHB1=#B0|_hmHI1=#B1|_hmHB2=#B0|_hmHI2=#B0|_hmVB1=#B1|_hmHB2DY=#M0" WHERE ID= 29
Updated 18-Jan-17 2:14am

1 solution

Start by looking at your data - to which we have no access - and check that an entry exists with an ID of "29". If no rows have that value, no rows will be updated.
Then look at your code to use that UPDATE command, and check the return value when you execute the SQL command - it should be the number of rows updated. If that isn't zero, then Access thinks it has updated some rows, so you need to check that you have the right DB, right table, and right data.

We can't do any of that for you: we don't have access to your code or your DB.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900