Access Denied when creating SQLite DB file

Question

I'm trying to create the database file to initialize it but I'm getting "Access Denied" error during execution. I think is something related with permissions but I'm not able to find any information that could fix it, since every guide I check does it the same way. This is an UWP application using C# and SQLite library. Thanks in advance for the help.

In the past I've tried to also create json file with other methods but I've never been able to create a file from a UWP application

Code that raises an error:

private const string DBName = "data.sqlite";

if (!File.Exists(Path.GetFullPath(DBName)))
{
    SQLiteConnection.CreateFile(DBName);
    RecentlyCreated = true;
}

Error message:

System.UnauthorizedAccessException: 'Access to the path 'C:\Users\myuser\source\repos\Pass\Pass\bin\x64\Debug\AppX\dataAccount.sqlite' is denied.'

Pavel Anikhouski · Accepted Answer · 2020-03-24 20:12:20Z

3

UWP has a very limited access to the user filesystem, as it described at File access permissions specification. You can use user libraries (downloads, documents) for storing the data (after allowing an access in appxmanifest file) or application data store (more viable in your case). Try to define DBName as

string DBName = ApplicationData.Current.LocalFolder.Path + @"\data.sqlite";

Or you can allow broadFileSystemAccess using link above

edited Mar 24, 2020 at 20:12

answered Jul 20, 2019 at 15:01

Pavel Anikhouski

23.6k12 gold badges66 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Peter Torr Over a year ago

The default working directory is the install location, which is read - only. Also be sure to check the SQLite docs re: temp directory.

mrcstr Over a year ago

Sorry for answering so late, I've been quite busy. Anyway, your help was extreamely usefull, thanks a lot!!

Collectives™ on Stack Overflow

Access Denied when creating SQLite DB file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related