Does escaping the single quote w/another quote work in MS-Access-land? If so, a regexp like:

$j0 =~ s/'/''/g;
[download]

Should do the trick.

A couple other possibilities to investigate:
* Does the $objDC support the binding of variables?
* Can you use DBI instead (i'm not sure offhand how DBI/ODBC mesh)?
If either of those are true, then the code becomes something like:

$SqlStr = "INSERT INTO tbl_jpgs (jpg_seq, suborder, filename) VALUES( 
+?, ?, ?)";
$dbh->do($SqlStr, {}, $rcd, $i, $j0);
[download]

And the quoting will be done automagically for you. One last note: please use the <code></code> tags for snippets.