I have a sqlite db for browsing and everything works ok when I'm compiling with the option "Debug".
If I'm changing to "Release" I get "android.database.sqlite.SQLiteException: not an error (code 0): Could not open the database in read/write mode." message when I'm trying to connect to database.
'Database hasn't been copied to read/write area
If FirstTime = True Then
If File.Exists(File.DirInternal,"thedatabase.db") = False Then
File.Copy(File.DirAssets,"thedatabase.db",File.DirInternal,"thedatabase.db")
End If
End If
Interesting, I had the same problem , one app has worked without a problem since day 1, now I've copied the basics into another app, using the same SQlite db and got this read/write error on Release.
Just by referring to File.DirDefaultExternal with Dim a As String = File.DirDefaultExternal in the Sub Activity_Create(FirstTime As Boolean) fixed the problem???????????