Access 07 Stored SQL Queries

Joined
Apr 20, 2009
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top