Many thanks for the speedy and clear reply. My understanding from this is that there is basically no (non-deprecated) way on Windows of programmatically specifying to SQLite the specific location to use for the temporary files that it uses and that the default Windows mechanisms/locations are used.