Hi Simon, Thanks for you quick response! I found the same reson. I now move my DB from "c:\program files\..." to "e:\..." (this is a separate data partition). The effect is now that with my DB tool (with and without admin right) I see the same data. Fine so long! :)
But my Windows Service (under LOCAL SERICE right) still see other data. :( I don't know how to fix this. Regards Steffen Mangold --------------------------------------- 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
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users