Simon,
"Are you certain you're not looking at two files with the same name in
different directories ?"
I am not looking in different directories, I will attach 2 pictures in wich is
shown a db called "prefs.db" and a "prefs - copia.db" with is a copy from the
"prefs.db". Both are been opened by the editor called "SQLittleStudio v2.1.3"
(that software allows me to show two databases opened at the same time), and
the first one has 8 tables and the other 11 tables. You will see there both in
the same directory too ("1.png" and "2.png"). The only difference is that the
path shown by "SQLittleStudio v2.1.3" has like a windows or linux format (with
the left or right slash), and according with the editor the file is a different
one, even in size, although the second one is the copy of the second one.
So, it seems that when I copy it and I try to visualize the copy with the
editor, windows goes to some other place to find the copy file. That´s
incredible!! I have never seen something like that.
Try renaming the database. THen try opening it under the original name under
both users.
When I rename it the content change in the same way than copying It . When I
open it executing the "SQLittleStudio v2.1.3" as administratror.
Any idea about what is happening?
Regards,
Berna
-----Mensaje original-----
De: [email protected] [mailto:[email protected]] En
nombre de Simon Slavin
Enviado el: miércoles, 10 de abril de 2013 0:22
Para: General Discussion of SQLite Database
Asunto: Re: [sqlite] A sqlite database changing the contents when I change the
database name or user rights
On 8 Apr 2013, at 2:16pm, Bernardino Flores/Jeanologia
<[email protected]<mailto:[email protected]>> wrote:
> I use both "sqliteadmin" and "sqlitebrowser_200_b1_win" editors to check the
> contents, and with both I observe the same problem. The problem is that
> sometimes I see 7 tables in the database and sometimes 11 tables. After some
> hours of looking for the problem I have realized that, if I open the database
> with the editor started as administrator I see 11 tables, if not only 7 (and
> those 7 tables have not the same contents as the 11 tables db, it seems a
> different database, an old one). It happens when I rename the database, too.
Are you certain you're not looking at two files with the same name in different
directories ?
Try renaming the database. THen try opening it under the original name under
both users.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]<mailto:[email protected]>
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
