Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a Microsoft Access database and I'm trying to open it. When I do, I get "Unknown User Does Not Have Permission". Is there any way to open this file? I'm using Microsoft Access 2007 under Windows XP.

Thanks.

share|improve this question
    
What is the extension of the "database"? Is it .mde/.accde, or .mdb/.accdb? –  sunk818 Oct 4 at 2:22

3 Answers 3

up vote 1 down vote accepted

It means that the database has a permissions file attached to it, and your login is not a part of the group that has permissions.

The easiest way is to ask the original developer for the user name and pwd that you can use to log into the database.

share|improve this answer
    
I don't know who exactly created this file, but I don't even see a way to log in as a user. Where do I enter username and password? –  Amir Rachum Dec 22 '09 at 17:48

Please post a screenshot so we can know the exact error.

If this is on entry, it is probably Microsoft DRM either protecting it over the network to a server in your company or over the Internet to the public Office DRM Server.

If it is protected by this, then I am not really sure we should help you to get around it - and not 100% sure you can.

If it isn't this, again, please post a screenshot so we can know exactly and I can try to help you further.

share|improve this answer
1  
What leads you to think it's DRM and not simply Jet user-level security, or a database password? –  David W. Fenton Dec 23 '09 at 21:53

You can also create a blank database, then use the link tables tables option to access the table. There might be a table called users where you can insert your login name. Then open the database directly and see if you can bypass the "Unknown User Does Not Have Permission" prompt.

If know a user that has access to the database, you can also try RunAs to impersonate a user that is on the access list.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.