I am using SQL to write to an MS Access db via JDBC. Whenever the word or word-portion "update" occurs within a text string I am trying to store, I get an error message that "update" is a reserved word, even though it has been correctly delimited (such as 'xxx ... udated ...xxx'). I have no trouble with other reserved words contained within text strings and also no trouble writing to an Oracle DB. To overcome the problem, I perform a checkWord function and insert a hyphen (viz. up-date); it greatly complicates things as this affects off-sets and I need to keep a count of the number of hyphens inserted.
Can anyone explain why this happens?