I'm testing sqlite on a network (Windows 2003 Server) share and with 5 users. I've created a "server" program which is ran from the same directory as the shared database. The program that the 5 users have, will read only from the sqlite database in that directory. Whenever they want to add a new record, I create the record in XML format and send it as a file to the shared directory. The server program is watching the directory for the xml file(s)...when one is "posted", it reads it in and writes to the database. Thus I have only 1 program writing to the sqlite database at any one time.
This environment is in testing and so far so good. Not one problem. The reads are very fast and using the xml/server program, the writes are fine (so far). I would like to create a synchronizer at some point in the future. Sorta replication to users local sqlite database reading from the server central data store (or something similar). Greg --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
