| Author |
Message |
| Registered: March 10, 2007 |  Posts: 4,282 |
| | Posted: | | | | Compare the assigned security privliges for the problem file with another file in the same directory. | | | | Invelos Software, Inc. Representative |
|
| Registered: March 18, 2007 |  Posts: 426 |
| | Posted: | | | | Ok, I'm getting closer.
I used Sysinternals's AccessEnum to check the file permissions on the database directory. This revealed 5 files which are Read/Write by 'Administrators' only. One of those files is COLLECTION.DAT. Among those are also Users.DAT and COLLECTION.BLB. I checked those files and I can't copy them from the desktop PC either. So it is definitely the source of the problem.
What I don't understand: these are Windows XP Home machines. I don't understand why these files should have r/w for Administrators only ?!
Now I have to find a way to reset these permissions... (probably another Sysinternals tool).
Ken: is it possible that 3.1 sets these permissions and they obviously are not what it should be ?
Or are there people sharing their database without problems ? |
|
| Registered: March 18, 2007 | | Posts: 426 |
| | Posted: | | | | Problem solved!
I eventually had to use CACLS from the Windows command line (in fact I used cygwin) to modify the file permissions for those 5 files. They were the only files in the entire DVD Profiler directory that didn't have C-permission (create/modify) for 'EVERYONE'.
I am pretty sure it must have been the 3.1 installation that somehow restricted these permissions, since I'm not that proficient in Windows XP that I would have done something like that myself. |
|
| Registered: March 14, 2007 | | Posts: 3,830 |
| | Posted: | | | | closed your laptop before closing the pc that still had access to collection.dat? | | | | Sources for one or more of the changes and/or additions were not submitted. Please include the sources for your changes in the contribution notes, especially for cast and crew additions. |
|
| Registered: March 18, 2007 | | Posts: 426 |
| | Posted: | | | | Quoting Giga Wizard: Quote:
closed your laptop before closing the pc that still had access to collection.dat? No, like I said: I started DVDP on the PC while the laptop is on, and got the errors. I would be interested to know what other users get when the do CACLS COLLECTION.DAT from the command prompt. If 'Everyone:C' is not there, they should have the same problem. |
|
| Registered: March 27, 2007 |  Posts: 98 |
| | Posted: | | | | Repter,
I had the same problem but didn't have the skills/knowledge to investigate it like you have. All I did was to create a new database and used the copy current database function of the create. This got rid of the problem. However I did run the CACLS COLLECTION.DAT you suggested and yes the old database file was as tight on permissions as you said.
Dave |
|
| Registered: March 18, 2007 | | Posts: 426 |
| | Posted: | | | | Guess what... Same issue again after upgrading to 3.1.1. Grrr... |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 5,491 |
| | Posted: | | | | Quoting Repter: Quote:
Guess what... Same issue again after upgrading to 3.1.1. Grrr... I'm a bit confused about this.., You don't have to be on the internet to run and operate and view your data base.., BUT when you log back in (internet) and want to upload or download new data , you could do this with any one of the two PC's but only the PC that transmitted will be the most current.. I also use 3.1.1 . | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry |
|
| Registered: March 18, 2007 | | Posts: 426 |
| | Posted: | | | | @widescreenforever: I think you have absolutely no idea what this thread is all about  . This thread has absolutely nothing to do with the online database. Summary of the issue: have DVD Profiler installed on 2 machines: laptop and desktop. The database is on the laptop in a Shared folder. The desktop DVD Profiler is configured to use that remote folder on the laptop for its database. This is a trick that several people use to be able to share the same database on multiple machines. This works very well, only thing to keep in mind is not run DVD Profiler simultaneously on both machines. (The reason why I needed this is that I can only sync my PDA on the desktop while the laptop is the preferred machine for DVD Profiler - so I needed a second copy on the desktop to be able to sync with DVD Profiler Mobile). The above worked perfectly until I upgraded to 3.1 and now again when upgrading to 3.1.1. The upgrade of the software also does an upgrade of the database when you first start it up. So I did that on the laptop. After that, I upgrade the software on the desktop as well. When I open up DP on the desktop it is then supposed to immediately be able to open up the remote database. But instead I get an error. The cause of the problem is that apparently, when doing the upgrade of the database, DP is changing the file permissions of some files, which results in the desktop no longer having access to these files, and as a result it cannot load the database. When upgrading from 3.0 to 3.1 there were 5 files that no longer had the correct permission. With 3.1 to 3.1.1 there are only 3 that have the wrong permission (all three are COLLECTION.* files). Anyway, it's not a huge issue anymore because I found the fix back then, so I could immediately apply it again. See my older posts in this thread. But I find it still very weird that those permissions are modified when upgrading. And most of all, it is pretty ugly to fix (you need to use some pretty advanced system tools). |
|