SQL insert command fails if your data has a dash ' in it
We had an Access database with the following VBA SQL insert command in it:
DoCmd.RunSQL "insert into scantemp (picture) values ('" & strFileJPG & "')"
This command would fail if the variable strFileJPG contained a dash ' in it. For example, if strFileJPG was:
this would error out.
The fix that worked was to use the chr(34) syntax instead:
Docmd.runSQL = "insert into scantemp (picture) values (" & Chr(34) & strFileJPG & Chr(34) & ")"
chr(34) is the ASCII code for the double quote character.