How to modify sqlite db file located in application folder

Question

I am using sqlite in desktop application. Once application is installed, a database file is created in installation folder (application folder in program files). I would like to modify the sqlite file, but can't.

When i try to modify, it shows read-only error in sqlite file.

I also tried to give permission to that folder, but it does not work.

What happens if you try and use something like SQLite Administrator to open the db? http://sqliteadmin.orbmu2k.de/ — gmdev86, Feb 07 '17 at 13:14
The thread linked to this question has absolutely nothing to do with the person's original question. — Developer Dave, Jun 15 '21 at 15:49

score 1 · Answer 1 · edited May 23 '17 at 12:33

1

You will need to create a copy of the .sqlite file and modify this one:

How to copy a file while it is being used by other process

Obviously you won't be able to write to the very same database file that your application has locked. And I cannot see any reason why you want to do this when the application is currently running. This would potentially lead to data inconsistency issues.

edited May 23 '17 at 12:33

Community

1
1

answered Feb 07 '17 at 13:02

mm8

163,881
10
57
88

How to modify sqlite db file located in application folder

1 Answers1