I've got a form that takes a string as an input. Upon submission, the string is inserted in an access 2007 table through the use of a stored query.
For the most part this works great. However, when part of the string corresponds to a sql statement (e.g. SELECT, IS [<=never seen this one before!], IN, etc...) my procedure crashes.
Is there a typical way around this problem? Do I need to create a "replace" function to handle these specific cases...
Thanks,
G
For the most part this works great. However, when part of the string corresponds to a sql statement (e.g. SELECT, IS [<=never seen this one before!], IN, etc...) my procedure crashes.
Is there a typical way around this problem? Do I need to create a "replace" function to handle these specific cases...
Thanks,
G