Read only attribute keeps resetting.

I have a Quickbooks installed on a Windows 2003 server. I have several users that remotely access the database (network version of Quickbooks). We keep having problems accessing the databes, and it always come back to them being marked read only. we've unchecked the read only box, and gone into the command prompt and set attrib -r on both Databases. When we check back later, the read only attribute is set again.

I've turned off inherited permissions on that entire folder, but something keeps tripping read only on those files. I cant find anything in Quickbooks itself that would do it, so I'm thinking it has to be something in Windows.

Any ideas on what could consistently set it read only?

LVL 1
DingusAsked:
Who is Participating?
 
Computer101Commented:
PAQed with points refunded (125)

Computer101
EE Admin
0
 
ocon827679Commented:
Why don't you turn on auditing.  I believe that you need to audit "Object Access."  Unfortunately you need to audit for success and failure so its easy to fill up your security event log quickly.  make sure you're only auditing the files in question.
0
 
DingusAuthor Commented:
Turned on auditing. Nothing showing up yet. These show up in the security event logs right?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
ocon827679Commented:
Yes - has the read-only bit changed?

0
 
DingusAuthor Commented:
I haven't been able to get back by there to check, and I can't get in remotely. As soon as I have an update I will post it.
0
 
DingusAuthor Commented:
Nothing is showing up in the auditing logs, but after some testing today, I can see the server itself has nothing to do with this.

Setup: We have the databases hosted on Server2003, QB Pro 2007 installed on the server and all 3 databases set on the server in Multiuser mode.  We have the Database Server Manager monitoring the databases so that it can 'serve' them properly.

I set Read Only attribue to off on all files in the DB folder. It stays off for a time. We noticed that when user A accesses Database 1, the Read Only attribute comes on on DB 3. If User B uses DB 1, the Read Only attribute comes on on DB 1. When User A gets out of DB 1, the RO attribute comes off of DB 3. When User B gets out of DB1, the RO attribute stays on. We rarely use DB2, so haven't done any testing on it. The Read Only attribute only sets on the DB files, not the other files in the folder.

We also noticed that after testing that the Database Server Manager was no longer monitoring the databases. We had to specify and rescan the folder to get it monitoring again. The service had not stopped or been restarted. It just stopped scanning/monitoring the databases (all are in the same folder).

The attribute settings make no sense here. How would User A opening DB 1 set the RO attribute for DB3?? We tested this several times, and it's consistent.

If UserB is in DB1, in Multiuser Mode, then User A can't get into DB1 and gets the Error -6177, Quickbooks can not open the path to the database. She can browse to it through the mapped drive, or by the open dialog in QB with no problem, but the error comes up the same.

I'm pretty much a Newby with QB, but this makes no sense at all to me.

Any ideas?
0
 
ocon827679Commented:
Don't know QB either.  This seems to be an application issue here.  I guess all you can do is call the app people or pose this question in another forum.  
0
 
DingusAuthor Commented:
Turns out the file attribute changes are normal. QB itself changes them depending on file usage. The mail problem was caused by a mapping error that I figured out and QB tech support had no idea. You have to map directly to the folder where the data files are kept, not a root folder with the data files in a sub folder. Once I remapped it, everything started working fine. Their tech support had no idea on that one. Figures.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.