Re: [Help-glpk] ODBC Connection to MS-Access - WHERE Clause Syntax problems

[Andrew Makhorin]

> The clause in the error message that says .[Manuf Code]=[0012LBLK]
> leads me to believe that it thinks 0012LBLK is a field name, and not a
> string constant.
>  
> Try switching double quotes and single quotes (I'm not sure that will
> work, but it's worth a try):
>  
>         "WHERE qProductsUnique.[Manuf Code]='0012LBLK'":
> 
> 

If a string literal is enclosed in single quotes (apostrophes), a single 
quote ' within it should be coded twice as '' (i.e. like in Fortran 77). 
However, the example above is also correct.