Interesting question, that I am hoping someone else encountered.
Running Xojo 2023 Release 3.1
OS: Mac Catalina
I am trying to open a database that I created YEARS ago, which always opens with my OLD password program.
If I try to open it with a new version, of which the only difference is in the first, the database is in the folder with the program, but in the new one it is a selected folder item it won’t let me select it.
If I open it with a DB viewer like sql manager (as it is encrypted) everything is there and it opens fine.
However, I can’t select it (and I am NOT doing any filtering to block file types).
Any ideas?
If it was corrupted then I should never be able to open it, correct?
This is difficult to understand. But if the database is in the Applications or Program files folder, or is in the same folder/subfolder as the app, then it will be treated as read-only by the operating system and it will not open.
Copy it to applicationdata or documents folders, and try from there
Sounds good.
I will try that and advise.
But it doesn’t explain why when I use the FolderItem.ShowOpenFileDialog(“”) to open it, one of my databases is selectable, and this one won’t let me select it.
And both of these databases were created EXACTLY the same. One was for work, one was for home.
(Don’t worry about all the versions… THAT is why I am going to allow the user to select a database. Before it was just for me, and FRANKLY a lot of those databases were created for testing… I just haven’t cleared them out.)
As to permissions… everyone can swim in the folder I keep the databases in.
