#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