Attempt to write a readonly database

Not using wifi. But as usual, after many attempts to fix this problem, it randomly fixed.

Because thats where all your other programs are, and where you are supposed to install programs?

Nothing usually wrong with having a document in ā€˜documents’, but having the program there isn’t normal.

That said, I know from experience that OneDrive and iCloud can cause issues for a document you want to get at, because if it is ā€˜in the cloud’ , it may not arrive from the cloud fast enough for Xojo to access. (Or Xojo may not include whatever mechanism is required to ensure that the download has completed before using the file.)

Turning off the wifi as Emile suggests is a good test of this.
It sort of makes sure that you have only a local copy before doing any work.

Another test would be to locate the sqllite file on a USB stick that isnt claimed by OneDrive.
You can put your app there too, if you really want to.

it randomly fixed.

Which means it could randomly fail again in the future.

1 Like

You must be talking about the xojo app. I’m talking about where my project is stored. In addition, my project is in debug mode, not compiled.

and I don’t use oneDrive or iCloud.

But what is that OneDrive in the path ?

Move the data base file to a proper place and make some tests…

Use SpecialFolder — Xojo documentation

SpecialFolder.ApplicationData.Child(ā€œMy App Dataā€)

This area is safe to read/write.

PS: you may access to the internet using an ethernet cable (not only wifi).
Windows is capable to do things in your back. The url you share to us leads you to think Windows is fooling you.

The real Document path does not holds \OneDrive in it. This is a Windows 10/Windows 11 novelty.

It’s not because you do not think you use OneCloud that you don’t use it. Microsoft was/is very agressive about people using OneDrive. The path you showed is typical of what happens when OneDrive is installed

C:\Users\jvsca\OneDrive\Documents

This is the local copy of the Documents folder of One Drive. When One Drive is installed, Windows is altered in order that when you create files and folders, by default they go on OneDrive. That means everything is on a Microsoft server, and can be seen and used by people you would not aloow them to. And OneDrive synchronizes the local store with the one in the cloud. The question is not if wut when your data will be corrupt.

My advise is remove OneCloud from you computer COMPLETELY. This is not easy but can be done.

2 Likes

Have you tested the given advice ? (moving the .sqlite file elsewhere)
And the result is…

As I said I found a solution, but I tried so many, I’m not really sure which worked.

Do really believe I store my projects in Window’s Program Files folder? Who does that?

Essentially ? Newbies.

I stored them in Documents until some years ago when I started ti use SpecialFolder.ApplicationData… and I am happy :wink: