Thanks; that must be a possibility. Will pass it on in case it happens again.
RBS -----Original Message----- From: Guy Hachlili [mailto:[EMAIL PROTECTED] Sent: 25 February 2007 14:26 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Locked database 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] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
