Data file sharing between two applications

[k.ali]

I want to create an application that stores data in a file (SQLITE).
I would like to be able to open it with another application, or with this same application in the event of a phone change.
Unfortunately, I find that when I want to open it after a reinstallation (not an update) I get this error message. -"Java.io.FileNotFoundException:/storage/emulated/0/documents/alsmi/WBack: open failed: EACCES (permission denied)"

it's as if each application can only open the file it creates itself. That's right?
If so, is there any possibility that several applications can use the same database?

Thanks for all the ideas

[TIMAI2]

@k.ali

it's as if each application can only open the file it creates itself. That's right?

Most often, yes, this is the case.

Each app has its own sqlite database, this is not shareable with other apps, as far as I know.

Some basics on Android storage system

From an Android point of view there are an → Internal Storage and an → External Storage . 1. Internal Storage The Internal Storage can only be accessed with a rooted device. 1.1 The app package is saved in /data/data/<packageName>/ In order to be able to debug your app, AI2 saves the assets for → Companion on devices with Android ≥ 10 (API ≥ 29): /storage/emulated/0/Android/data/edu.mit.appinventor.aicompanion3/files/assets/ Android < 10 : /storage/emulated/0/Android/data/edu.mit…

You could use an online resource to store your sqlite.db, and import it to different applications as required...this will be a bit messy especially if you have multiple users....

You could also work with google sheets....

• Integrating SQLite with Google Sheets

and I forgot to mention SAF (storage access framework)

[Anke]

@k.ali

I would like to be able to open it with another application

You need SAF for this on Android 11+. On all other Android versions you (only) need READ permission to open / read it and WRITE permission to save data.

[k.ali]

Great! Thank you both
SAF seems good