This has nothing to do with SQLite sadly, but still easy to fix. It's the WIndows UAC which is doing this to you, as it should for
data that it tries to protect.
I am guessing you have the DB in a protected location, such as somewhere within c:\Program Files\ or in c:\Windows\ or such... or in
the actual same folder as the exe that you use.
The UAC will then copy your file (at some initial point) to a substituted "Safe" folder and only edit that file, cleverly avoidining
any system changes to the original by anyone, UNLESS of course, you start up Admin mode, in which case Windows no longer subjects
your file to the protection, and allows you to edit/access it normally - BUT, this is now an entirely different file with entirely
different content than the one in the "Safe" location.
The "Safe" location should be somewhere inside c:\Users\YourUser\Appdata\Roaming\... etc (Just search for it from one of these base
folders). Your "other" version of the file will be here.
Now as to fixing it, well, that is easy too - just move the file to a non-protected place. My suggestion is of course the Appdata
path itself, which windows will allow you to change most anything in without asking user permissions. My Documents is another option
(but end-users usually fiddle there, so if this is a end-user type program, best not).
You should never keep any config files or any files accessed by your program in the same folder as the exe or indeed any of the
mentioned protected folders. (Standard Windows path-names exist for all users for all these special folders, easily accessible from
the shell, just google it).
Good luck!
On 2013/07/03 23:41, Steffen Mangold wrote:
Hi,
I have some strainge behavior with a SQLIte DB.
If I open the database with my DB tool with administrator right I see other
data as when I open the DB with my tool in non admin mode.
Is this normal? And if yes can I deactivate this?
To be clear:
I start my DB tool normal (local user account) and open my DB (c:\my.db3)
I see only data entry A.
If I open my DB tool with admin rights and open the same DB.
I only see data entry B.
Regards
Steffen Mangold
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
