Dear Users, Windows 10 Photos App is no longer able to find my files when opening the app. I discovered that the App uses Sqlite and using DB Browser for SQLite I was able to display the Table folder which shows the many different folder paths I believe the App is referencing (see attached).
The original folder paths have all changed and the photos etc have been consolidated into a single directory (E:\Photos). I tried using the following sql commands to change the folder references for each entry. The sequence appears to execute correctly but I can’t find a way to update or write the database. select folder.Folder_Path, replace(Folder_Path,'C:\Users\carlo\Pictures','E:\Photos') from Folder where folder.Folder_Id = 1 Could someone kindly educate me on how to update the folder references? Kind regards, Carlo. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
