Thomas It is not safe to use SQLite on networked drive because of file locking problems and how OS caching takes place. Please refer answers by DRH above as well as in other question-answers.
Different OS have different file locking and caching mechanism. Probably Windows 2000 might have suitable one to what SQLite database needs. That is why I asked about if any one has idea/experience of sharing SQLite database by multi-users while file is on Windows 2000 (in perticular). Regarding sharing MS Access database file: You should not keep database file on Windows 95 / 98 / (ME) file share but keep it on Windows NT/2000. In some MSDN articles, microsoft recommends about sharing MS Access database : - Do not keep database file on Windows 95 / 98 / (ME) file share - Store the database file and that you share the database file on a Windows NT server or on Windows 2000 server with opportunistic locking disabled. Please refer (Knowlegde Base Articles) -> How to keep a Jet 4.0 database in top working condition. -> How To Synchronize Writes and Reads with the Jet OLE DB Provider and ADO -> How To Synchronizing Reads and Writes Between Two DAO Processes Especially refere to topic, "Issues to consider when you share a Microsoft Jet database" Rohit -- View this message in context: http://www.nabble.com/Using-SQLite-on-networked-drive-tf1213767.html#a6499937 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
