Hi, I'm having the following problem: a sqlite database file is on an NTFS filesystem, in a directory with no permissions to create new files, but only to modify the original database. By using filemon i've noticed some access denied errors when sqlite attempted to create the journal files. I've created a sepparate test case and (by using filemon again) i've noticed that indeed, sqlite uses the journal file, even outside transactions (an insert sql was executed).
My question is how can I stop this behaviour (creating/deleting the journal) so that sqlite will work properly under the scenario described above (when it can't create the journal)? PS: Yes, I know, I'm still google-ing, but I'm not having much luck, that's why I'm posting here.. Thanks! -- ...it's only a matter of time...
