Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Basically I secured the database to only open fully on one system but now I need to change it from another system. Is there anyway I can do this?

Edit: The database is a .accdb
I changed the file privileges by right clicking the file

share|improve this question

migrated from Aug 20 '13 at 14:28

This question came from our site for professional and enthusiast programmers.

If you set it based on users, then try shift+right clicking and run as a different user? This will most likely only work with network/AD computers though. – Grant Aug 20 '13 at 11:37
Thanks for the response, the problem is is that I did the work in their company and now I need to fix it from my computer in a different building. I have it on a usb. I suppose I am going to have to travel to the company and edit the security there and bring it back here? Thanks, Kieran – user2199734 Aug 20 '13 at 11:41
What if you were to open the file, do a Save as as a different copy, and then just replace the old one with the new modified one at lunch time when everyone logs off. – Grant Aug 20 '13 at 13:17

You must log in to answer this question.