Hi,
I get this error when i have generated a playlist and want to save this action.
[FireDAC][Phys][SQLite] ERROR: attemt to write a readonly database.
I think i know what is happening but how could i undo or repair this?
Version is 5.3
Greetings Rob Wennekers
Check the permissions of the database file and the folder that contains it.
I did and it seems that they all have the same rights as the Administrator.
What’s the location of the database file?
First i put the database (mldb)on the C disk and after that because it doesnt work i replaced to windows/documents but also negative
Extra info:
I copied the database from another PC 32bit where it worked fine to a 64bit PC. (Upgraded it from v22 to v23) That also worked fine.
After that i copied again to my final 64bit PC and i get the error.
Gr Robbie W
C:\ (root folder of drive) won’t probably work because of UAC. Even if you are an admin user, all running software will have restricted access to some folders, in particular C:\Windows, C:\Program Files, and so on.
Best thing is to use the mAirList data folder (see config -> Advanced -> Data Folders), or somewhere in your personal data folder (C:\Users<Username>\Documents etc.).
Hi Torben,
I understand what you say and thats why i put it by myself in (C:\Users<Username>\Documents etc.).
Thats what i meant in this answer before:
(First i put the database (mldb)on the C disk and after that because it doesnt work i replaced to windows/documents but also negative)
But for now thanks and i will try some things this evening to repair it.
Gr Robbie w
Still sounds like some kind of permission problem to me.
Remember that not only the database file must be writable (wrt. file permissions, and not set to read-only of course!), but also the folder that it is contained in, as SQLite will need to create some temporary files in it during the write operation.