There are many suggested ways to do this in the knowledge base. I frequently build extended (multiple fields) query strings during processing so I need to be able to use single quotes to deliniate character strings being put into text fields. Should I:
Store substitue characters for the single quotes in the fields - ackward when the table is also being used directly in Access (my storage database),
Process each field individually using a variable to accomplish the insert/update - isn't this a lot of database thrashing, or
(hopefully) something else that is a bit more elegant (efficient).
I didn't include code because their are a gillion ways to do each of my first two listed alternatives. I'm really interested in a third alternative.