It turns out there is a special way to do this by using parameters in the 'where' clause and then using a method to set those parameter values before executing
I think I'm sure that the query passed to Access contains those extra quotes. My program inserts new rows if the query is a simple "SELECT * from pens" (funny
I guess it is a debugger 'thing'. If I print the string I've generated then it's fine. However the same string assigned to the ODBCREsultSet.query shows the
No, this is a function we include in a standard script library that we share across all our applications. _____________________________________________________