Hello.
At 13:37 2/25/2007 +0000, you wrote:
Came across a situation where it was impossible to delete or rename a SQLite
db file even after the application (Excel) that had locked the database was
closed. It wasn't me, so I don't have very exact information, but there was
a statement to create a table and to insert data. For some reason this
couldn't be completed and there was a db file and the corresponding journal
file.
I thought that it should be that closing the app that initiated the db
connection should always release the handle to the db and allow deletes of
renames of the file.
If this is not so then should I maybe write the db handle to a safe place,
like an .ini file, so I could use it later to close the db.
Also would there be a way to release this db lock without a reboot of the
PC?
I have had a lot of experience with Excel crashing the UI and leaving some
Excel application running in the background.
Open the task manager (Ctrl+Shift+Esc) and check to see if you have any
Excel leftovers in the Processes tab (NOT in the Applications tab!). If you
do, just select them and use the End Process button to close them. The DB
file should be freed.
Guy
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
