Unscrewing an Access d/b permissions
January 28, 2010 10:36 AM Subscribe
How do I regain write permissions for an Access database.
posted by diode to computers & internet (6 answers total)
I am just starting to use a workstation at a new position. The OS is XP w/ service pack 3. The PC is not secured by the IT staff. I have login access to the admin user and am logging in as another user (sales). The IT guy here is a Linux guru, and doesn't know how to fix the problem.
I've been using an Access database located on the C drive. I switched the sales user to being a regular/limited user from having admin rights in order to better lock down the machine.
Now I cannot launch the Access d/b. The folder it is in (access) is read-only. I've tried setting the sales user back to having admin rights, and also tried logging in as the admin user and changing the read-only setting on the Access folder.
The admin user can launch the d/b now. When I try as the sales user, I get an error that the d/b is read-only. I'm totally set up to use the sales login and don't want to have to redo stuff as the admin user.
What can I do to unscrew this pooch? I'm looking for the permissions but cannot find them. The properties for the access folder only shows the Read-only setting. When I unclick the read-only button as the admin user, they revert to read-only next time I look at them.