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