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 Again, if I run the command-line tool as Administrator, all of the data appears as expected. I don't mind if sqlite is unable to read a file due to permissions making it impossible, but the fact that it reports success and gives me only partial information is driving me bonkers. Any ideas for a work-around, other than checking the Windows permissions by hand? The problem occurs with both sqlite 3.3.4 and 3.6.4 Any help is appreciated. Thanks, -- Daniel Stutzbach, Ph.D. President, Stutzbach Enterprises, LLC <http://stutzbachenterprises.com> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
