# Problem with MEMO in DB Access

**URL:** <https://forum.xojo.com/t/problem-with-memo-in-db-access/73993>\
**Category:** General\
**Created:** [January 9, 2023, 3:14pm UTC](https://forum.xojo.com/t/problem-with-memo-in-db-access/73993 "2023-01-09T15:14:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Federico\_Giannetti](https://forum.xojo.com/letter_avatar_proxy/v4/letter/f/a4c791/32.png) [@Federico\_Giannetti](https://forum.xojo.com/u/Federico_Giannetti)\
**Post date:** [January 9, 2023, 3:14pm UTC](https://forum.xojo.com/t/problem-with-memo-in-db-access/73993/1 "2023-01-09T15:14:21Z")

</div>

Hello group, one of my usual problems. I have a MEMO field of an Access DB… I want to update it in case there is new information or leave it empty…

```auto
rows.EditRow
if TextField10.Text="" then    
  rows.Column("Note").StringValue=""
else
  rows.Column("Note").StringValue=TextField10.Text.ConvertEncoding(Encodings.WindowsANSI)
end if
rows.SaveRow
```

The error is:  
[Microsoft][Driver ODBC Microsoft Access] Errore di sintassi nell’istruzione UPDATE.

WHY ?

---

<div class="post-metadata">

**Author:** ![Ant\_Col](https://forum.xojo.com/letter_avatar_proxy/v4/letter/a/c0e974/32.png) [@Ant\_Col](https://forum.xojo.com/u/Ant_Col)\
**Post date:** [January 9, 2023, 4:01pm UTC](https://forum.xojo.com/t/problem-with-memo-in-db-access/73993/2 "2023-01-09T16:01:49Z")

</div>

Inglese

the problem is that you have christened your column “Notes”. This is a reserved word of SQL… access makes you create the column, but if you run SQL query it gives you error… DAYS TO FIND THIS THING YEARS AGO! 🙂 since then I’ve been programming using my (I think our) language, Italian, so I call a “note” field “appunti” 🙂 joking aside, you can simply call it “note1”, you see…

---

<div class="post-metadata">

**Author:** ![Federico\_Giannetti](https://forum.xojo.com/letter_avatar_proxy/v4/letter/f/a4c791/32.png) [@Federico\_Giannetti](https://forum.xojo.com/u/Federico_Giannetti)\
**Post date:** [January 9, 2023, 4:05pm UTC](https://forum.xojo.com/t/problem-with-memo-in-db-access/73993/3 "2023-01-09T16:05:17Z")

</div>

Thanks Ant…I’ll change the name of the column…

mi stavo a ricongli… 🙂
