ACCESS

[Paul Szynol]

hello, everyone,   is anyone out there working with access??   i am having an on-going difficulty.   preparedStatement truncates memo fields to 255. setObject as opposed to setString does not fix the problem, as someone suggested it should.   Statement works, in the sense that it preserves the full size of the input, but a conflict occurs when the user enters a single quotation mark (') into the field, since access interprets this quotation mark (') as an end of field mark.   so, my question is, how can i use memo in access without 1. truncation and 2. confusion when the field contains a single quotation (') ?   i'd very much appreciate help.   best, paul