NTFS permissions resetting on Access MDB every time it's opened.

Hello all,

I have searched far and wide for a solution to my issue. In short, here is the problem:

1. 3 PC's enter data into an Access 2003 database (PC's are running Vista w/ Office 2007 pro). The database has been used for a long time and we haven't upgraded it to a 2007 version database.

2. One of the PC's hosts the "master" database, the 2 others are using Replica's of "master" database. At the end of each work day, the "master" PC Sync's his database with the 2 other replica's via the Sychronize database option. He would navigate the "Browse" window to a share that was created on each of the other 2 PC's that held the database. This worked fine until we upgraded from Windows XP pro w/ Office 2003.

3. Now whenever the master attempts to sync the database over the network with the other 2 PC's, he gets an error message stating the database was not found in that location. The database IS there, it just doesn't show up in the "browse" window.

4. I've traced the problem to security permissions being removed from the .MDB file whenever MS Access opens the file, whether it's one of the Replica's or the Original, it always resets the permissions. I have to manually go back into security permissions of the .MDB file, and add the "Everyone" user and set it to "Full Control". After this change the "master" database can sync with the others just fine.

5. HERE's THE PROBLEM !!! -- Every time one of the users opens there copy of the database, it reverts the permissions back to "Administrator", "System", and "Username". The "Everyone" user is gone every time. Now I have set the parent share folder to propagate all inheritable permissions to it's children objects, but it never keeps the "Everyone" user even though the parent folder has "Everyone" with full control to itself and children (Share users and Security users).

6. Every time they try to sync there database at the end of the day we have to add this "Everyone" user with full access to the security permissions before they can sync. This needs to be fixed. I tried adding the "everyone" user to the %temp% folder permissions as others have suggested to no avail. I also tried keeping the replica's in the Public defualt share in Windows Vista, still no "everyone" user.

7. Last thing I think that would help to know is that every time someone opens the database, no matter what, it will say Repairing with a quick progress bar in the bottom right of the MS Access 2007 window, then the database opens about 3-5 seconds later.

So for my conclusions, this is a NTFS permissions issue. I think when the database is opened, a copy is created during this "Repair" it's doing, and then the "repaired" copy is placed in the folder and the original is removed. This being a NEW file, it somehow has new default permissions assigned. However, the parent folders security permissions are not being inherited properly by the .MDB file. If anyone can help me on this issue it would be greatly apprecitated.

re: NTFS permissions resetting on Access MDB every time it's opened.

The only thing that I have been able to find so far is the following:

Annoyance: If you have multiple versions of Access on your computer, Access 2007 runs an installation again to re-register itself each time you switch version. Even on a fast computer, this delay is tedious - almost long enough to make coffee. Some earlier versions (such as 2003) also re-register themselves when you start them after using Access 2007.

http://allenbrowne.com/Access2007.html#Bugs

re: NTFS permissions resetting on Access MDB every time it's opened.

I don't see any installation starting, and we are not using multiple versions on the same computers. All computers are solely running Vista + Office 2007. "Everyone" Full access permission is dissappearing from the the .mdb files making it impossible to sync with the replica's regularly. Someone please help, is this a Vista issue? I don't think it is becuase it seems to only happen with .MDB files...

re: NTFS permissions resetting on Access MDB every time it's opened.

Ok, I tend to agree with you. There was nothing specific to your problem in MS KB, so I am providing you with a few things that you can do based on your assumption that it is an NTFS problem.

1. Right-click on the shared folder and select Sharing And Security. The Properties dialog box for the folder should display four tabs: General, Sharing, Web Sharing, and Customize. Select the Sharing tab, and it should be divided into two sections: Local Sharing, and Network Sharing And Security. Make sure the Network Sharing is set for the shared folder, and that local sharing is turned off.

2. If the location of the shared folder where the mdb resides was changed when you upgraded to Office 2007, the permissions that were on the old shared folder may not have transferred to the new shared folder. In order to check this:
Log on as an administrative user, right-click the folder in question, choose Properties, click Security, click the Advanced button, and click the Effective Permissions tab. Select a user or group to view the effective permissions for that user or group on the specific file or folder. Are they correct?