Andreas,
Are you possibly running into:
http://en.wikipedia.org/wiki/Shadow_Copy
http://windows.microsoft.com/en-ca/windows-vista/previous-versions-of-files-frequently-asked-questions?
I have checked the service VSS and is stopped. I will attach the same e-mail
that I sent to Simon Slaving, another user in that group.
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 Andreas Kupries
Enviado el: miércoles, 10 de abril de 2013 0:21
Para: General Discussion of SQLite Database
Asunto: Re: [sqlite] A sqlite database changing the contents when I change the
database name or user rights
Are you possibly running into
http://en.wikipedia.org/wiki/Shadow_Copy
http://windows.microsoft.com/en-ca/windows-vista/previous-versions-of-files-frequently-asked-questions
?
(I guess that when you say 'administrator' you are talking about Windows Admin.
On Mon, Apr 8, 2013 at 6:16 AM, Bernardino Flores/Jeanologia
<[email protected]<mailto:[email protected]>> wrote:
> Hi,
>
> I have found a problem with a sqlite database which I cannot find any
> reasonable explanation for it.
> 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.
> Have any found a problem like this? Could it be a windows 7 operative system
> error, when indexing files?
>
> Regards,
>
> Berna
>
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]<mailto:[email protected]>
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Andreas Kupries
Senior Tcl Developer
Code to Cloud: Smarter, Safer, Faster(tm)
F: 778.786.1133
[email protected]<mailto:[email protected]>
http://www.activestate.com
Learn about Stackato for Private PaaS: http://www.activestate.com/stackato
Tcl'2013, Sep 23-27, New Orleans, LA, USA @ http://www.tcl.tk/community/tcl2013/
EuroTcl'2013, July 6-7, Munich, GER
_______________________________________________
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
