I'm trying to update or even add large amounts (article size) of text into an Access field, but it seems like it's limiting me, how do I get around this?
Set field type in Access to memo insted text. That should do (unless you text is lager of 32000 characters).<BR><BR>firstname.lastname@example.org
The field is memo, the problem is that the update query i'm running won't update with apostrophes (') or commas (,). Is there a way around this?
Replace the apostrophes with two apostrophes by using the function: strMemo = Replace(Request.form("strMemo"), "'", "''")<BR><BR>Commas should not be causing a problem.