On 26 Oct 2009, at 8:21am, Mark Flipphi wrote: > Now an other application is running on a desktop pc and opens the > database from the server harddisk (shared drive)
Please verify for us that it's using a standard Windows shared folder. This tells us how the sharing is achieved. > We need to be able to acces the data in the database, but the database > is almost always locked. > This application is reading the data and needs to be able to > occasionally store some fields. > > I think it has something to do with the BEGIN that locks the database. Take a look at http://www.sqlite.org/lang_transaction.html and see which of the three BEGINs would suit you best for each of the two programs: the one that does the writing and the one that does mostly reading. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
