Faced the problem that a value> 255 characters (MEMO) cannot be passed to a request with parameters, which causes an "invalid property value" error.
If the insertion is done with the query through currentDb.Execute("INSERT INTO ... VALUES") , then everything is fine, but the method may stumble on a line where the text will have quotation marks => you need to escape everything.
Tell me, is it possible to get around this somehow (problem with queries with a parameter)?
If not, are there standard screening methods or do you need to handle quotes before calling execute ?
