Daniel Stutzbach <[EMAIL PROTECTED]> wrote: > I'm running into an odd problem on Windows Vista relating to > permissions. I've got a small (77 KB) sqlite DB owned by > Administrator. When I access it as Administrator, everything works > fine. If I try to access it as a normal user... things get funky. > This is what I observe using the sqlite command-line tool as a normal > user: > > - .schema works > - .dump shows all of the CREATE commands, and 3 INSERT commands > (although there are more than 100 rows in the DB) > - SELECT shows the same 3 rows. Most tables appear empty. > - No errors are generated
Which folder is the database file in? Thanks to Vista file virtualization, you are probably looking at a different file altogether. See http://support.microsoft.com/kb/927387 "Scenario 2: You cannot find the file or the folder that you just created" section, http://msdn.microsoft.com/en-us/library/bb756960.aspx "File Virtualization" section. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
