Welcome to our community! It is on a network file server and is accessed via network shares. Further if either of the 2 new users log on first, any of the original users can use the database but only as read-only. Both original and new users all have the same NTFS permissions to the database and folders on the network. Any help to solve this will be most appreciated.
Join our community to see this answer! Unlock 1 Answer and 6 Comments. Andrew Hancock - VMware vExpert. See if this solution works for you by signing up for a 7 day free trial. Is there anything else I should do to rectify this problem guys?
Joined Aug 5, Messages 3, I was under the impression dfriend meant establishing write permissions for the Windows user to the network folder, not creating write permissions for users within Access's own security features or to the database file itself. Windows users must be able to write to the folder where the database resides in order to create lock files.
HTH chris. I read your posting. Thank you very much. I went to the network folder, I right clicked and selected properties. I clicked on the Security Tab. I clicked on the 'Advanced' tab and under the user's name I find that all the the necessary permissions have been selectcted, just like in the case of the users who do not have the 'could not lock file' error. Just to make sure everything is ok, I went into the folder and right clicked on the application.
I found this strange as for the other users, the ticks in all three boxes were greyed out. The other thing I noticed was in the Advanced security settings, for this particular user's name, the 'Inherited from' column says : not inherited.
I am quiet confused, anything else I should do? Hi Folks I have to add a new user to the database. This is what I tried: I right clicked on the folder holding the database. I selected properties. In the general Tab, there is an option called 'add'.
Is this the way to add a new user for the databse? If I go into the folder and double click on the database. What should I do? Hello Glisandro, Unfortunately I was able to answer my initial question but I do not have enough experience to address your questions. This can be tested by opening the folder of interest from the user's machine and creating a file. An easy way to do this is to right click on the empty space, then choose new, text document. You should be able to create a txt file and then erase it.
If you cannot do this then you will need to change settings before proceeding to Access. I have not tried to use the database. As Seen On. Welcome to Tech Support Guy! Latest posts. Administrator account 4 Viewers Latest: lunarlander 5 minutes ago. Windows Windows 7. Microsoft confirmed the Microsoft Office security update released on Tuesday December 14, causes Microsoft Access databases on shared drives to be locked after users exit the database.
This prevents other users from opening the database and multiuser database sharing. Customers reported errors like:. This is due to the December 14, Patch Tuesday update to Office. The problem was introduced by a security fix, so it impacts all active versions of Access. There will be a page added to the Fixes or workarounds for recent issues in Access microsoft. If you have one of these builds, the only solution is to move back to an earlier build in the channel.
Microsoft published this new page with the latest information on this issue Error in Access when opening a database on a network file share.
0コメント