#7552
Support 3
Participant

Another thought, may be you can store the database to a FTP site. The applet will download the DB from the FTP site and store into user’s computer. The applet can check the date stamp for the DB and download once each day to avoid download per execution. You can also automate the process to upload the file to FTP. See below a sample code to download from web.

  
iFileName = "http://www.mycompany.com/data/mydb.db"
set oHTTPConnection = Utilities.HTTPConnection
iBuffer = oHTTPConnection.Get(iFileName)
call utilities.SaveStringToFile(iBuffer, "c:tempmydb.db", true)
set oHTTPConnection = nothing

Hope this helps.

Regards,
Advansys Support