I am using SQL lite in a word VBA application. An SQL query to select a value from a table is executed during the activate action of the form that loads on startup. Most of the time, it works ok, however, it throws up on the connection to the table once in about 20 times that the form is started up. Once the form loads with no problems, several connections and queries are made with no problem.
I have just added functionality to insert a record to a back up table on a nas drive. Same issue, once in a while it fails connecting to it to insert a record. Restarting the vb application and retrying the insert works. Any ideas would be greatly appreciated. Thanks -- View this message in context: http://old.nabble.com/Intermittent-connection-failure-tp31520729p31520729.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
