Hello,
I've got a problem with using a sqlite database file which is situated inside the \programs folder. When i try to access this file as a non-admin the connection needs about 1.5 seconds to be established and then the read-access works without a problem. Connecting to that file with administrator-rights it connects immediately. Is there anything i can do about that connection delay as non-administrator?
thanks in advance,
nils
SQLite-DB in Programs Folder
Re: SQLite-DB in Programs Folder
hello,
Such behaviour is due to that SQLite creates temporary files (journals, inner tables, etc.). And since the Program Files folder is not writable for a user with limited rights, sqlite, first, tries to create these files there, and after this couldn't be done, it tries to find writable folders and to create the files there
Such behaviour is due to that SQLite creates temporary files (journals, inner tables, etc.). And since the Program Files folder is not writable for a user with limited rights, sqlite, first, tries to create these files there, and after this couldn't be done, it tries to find writable folders and to create the files there