Chris, you have an extra pair of single quotes in your original code compared to Simon's suggestion. Also in your parameter-based attempt you have a typo when assigning the path (@DNName instead of @DBName).
Hope that helps, -Rowan On 31 July 2015 at 15:09, Chris Parsonson <z2668856 at gmail.com> wrote: > That's exactly what I started with, then somebody suggested using a > parameter > > On 31 July 2015 at 09:02, Simon Slavin <slavins at bigfraud.org> wrote: > > > > > On 31 Jul 2015, at 5:32am, Chris Parsonson <z2668856 at gmail.com> wrote: > > > > > SQLStmt = "ATTACH '" & sUpdateDBPath & "' AS UPD" > > > > This is not the correct syntax for the ATTACH command. The name of the > > file to be attached is not a value, it's just included in the command. I > > would expect you to have better results using something like > > > > SQLStmt = "ATTACH " & sUpdateDBPath & " AS UPD" > > > > You must, of course, make sure that the sUpdateDBPath specifies a place > > that your application does have access to. You can test this by > inserting > > a few test lines which open a database of that location. > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Chris Parsonson > 083 777 9261 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
