- Local time
- Today, 00:37
- Apr 3, 2020
NOTE is on Allen Browne's reserved word list
THAT WAS IT! I changed it to ContactNote and then updated my code to reflect the new change and it's worked.... Don't make it easy sometimes do they? XDNOTE is on Allen Browne's reserved word list
INSERT INTO Table1 ( N, [Note] ) SELECT 2345 AS N, "ABCD" AS Expr1;
lots of words are left off that list ... maybe you should fix it, @isladogs -- oh I guess you can't since it's not on Docs ... there is probably an incomplete list somewhere there too -- although that list is just for SQL, not also AccessInteresting that Note isn't on the official MS list of reserved words!