Thank you for your response. To answer your questions: Ryan: It's sad to see someone get dismayed with what is usually a flawless working system. It's not the database that's tricky, it's the reason the file is locked. This would be a problem with a string based file too. - I agree Ryan, but I get SO totally frustrated [and locked myself :-)] not being able to go on with my favorite hobby!!!
Do you have it open in any DB manager or other CLI or such? - I have just tried SQLite Manager and in fact I am able to edit in the db through this program What's the actual path of the folder containing the file on your drive? - My database (called flashcard.db) is placed in a subfolder to %programdata% (c:\programdata\my name\flashcard_data This leaves other possible culprits as Windows Virtualization - Personally I do not know much about Windows Virtualization. I will try a search!! and possible other programs/processes on your machine locking the DB file. - I am totally empty about what kind of program that might be?? Thomas: Could the problem arise due to filesystem corruption? Have you tried an fsck? - no I have not tried an fsck [is this not a Linux prg that checks the files?] Chris: Close your application. Is there a xxx-journal file in the same directory as the database? (where xxx is the name of the database) Try deleting this file. - there is no such file in the database directory Best Regards Lars -----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Chris Locke Sendt: 12. oktober 2018 18:22 Til: SQLite mailing list Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked > Database is locked Close your application. Is there a xxx-journal file in the same directory as the database? (where xxx is the name of the database) Try deleting this file. Thanks, Chris On Fri, Oct 12, 2018 at 4:54 PM Thomas Kurz <sqlite.2...@t-net.ruhr> wrote: > >> Could the problem arise due to filesystem corruption? Have you tried an >> fsck? >> >> >> ----- Original Message ----- >> From: R Smith <ryansmit...@gmail.com> >> To: sqlite-users@mailinglists.sqlite.org < >> sqlite-users@mailinglists.sqlite.org> >> Sent: Friday, October 12, 2018, 17:35:28 >> Subject: [sqlite] error message: [FireDAC][Phys][SQLite] Database is >> locked >> >> On 2018/10/12 2:44 PM, Lars Frederiksen wrote: >> > I have tried that too! - I must admit that right now I am turning to a >> KISS solution: String-based database with functions and procedures in a >> class that handles the different jobs you do on a table. After all these >> old-fashioned DB's are not so picky :-) >> >> It's sad to see someone get dismayed with what is usually a flawless >> working system. >> It's not the database that's tricky, it's the reason the file is locked. >> This would be a problem with a string based file too. >> >> Reading the above, I'm no longer convinced it's your anti-virus' fault >> either. >> >> Using Delphi FireDAC quite a bit, I can promise you that its SQLite >> connectivity is working just fine, and while an Antivirus can lock a >> file for the time it takes to check it, unless your database is >> Gigabytes in size, that lock should be released within milliseconds, >> unless found to be unsafe - but then the log should speak of it (which I >> assume it doesn't). >> >> This leaves other possible culprits as Windows Virtualization and >> possible other programs/processes on your machine locking the DB file. >> Do you have it open in any DB manager or other CLI or such? >> What's the actual path of the folder containing the file on your drive? >> >> >> Cheers, >> Ryan >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
