Database Access (1 Viewer)

[pato_mld]

Hi,

I'm trying to access the moving pictures database file using MS access so I can run a simple query to set all my movies as watched. It's asking for a password so I'm wondering if A) I'm using the wrong program, or B) If there's a password which is freely given out or C) Tough luck, this is locked down for my own benefit.

Thanks in advance for any info.

Couldn't figure out how to delete this post. I figured out that I'm supposed to use the SQLite Browser and update the user_movie_settings table.

 

[marvenius]

Yes you are using the wrong program (still, even with SQLite Browser ).
When you open the configuration, select all movies, and then set the watched flag, it will update all selected movies.
Much easier and no risc of corrupting the database...