A very simple way is use an exclusively opened file as a lock.
RohitPatel9999 wrote:
Hi I need some help on this. I need to create a new SQLite database with all necessary tables, records and indices. Database file must be removed from disk if any error while creating/copying tables, records or indices. Other application or other instance of same app must not be able to access the database, till database is not ready with necessary minimum tables and records. Question is: How to maintain exclusive access to disk db file till creation/copying from memory db is finished ? Thanks Rohit -- View this message in context: http://www.nabble.com/RE%3A-Dumping-Memory-DB-to-File-t1601385.html#a5033569 Sent from the SQLite forum at Nabble.com.