Microsoft Access error – You do not have the necessary permissions to use the…

When trying to open an Microsoft Access 2003 database that has security features enabled you may get the following Microsoft Access error displayed “You do not have the necessary permissions” on newer versions of Access:

You do not have the necessary permissions to use the ‘.mdb’ object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

You do not have the necessary permissions

To overcome this slight problem, you need to create a shortcut and link the MDW (Microsoft Access Workgroup information file) with the MDB .

You will need to create a new shortcut Right click New > Shortcut>. When asked type the location of the item. You will need to enter the following, replacing MDB/MDW> to where your files are located and the version of Office you are using. It may be worth opening notepad so you can get the path right and then copy and paste.

* Please note the quotes are required

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" ".mdb" /wrkgrp ".mdw" /user

Replace Office14 with your version of Microsoft Office that is installed. To find this, browse to “C:\Program Files\Microsoft Office\ and note the “Office” folder.

You do not have the necessary permissions

So for example, a correct path would look like:

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "c:\test.mdb" /wrkgrp "c:\test.mdw" /user

Before creating the shortcut, you can test if this will work by going Start > Run and pasting the path into the run box and clicking ok, if this fails then the shortcut will fail. Check the quotes and path to ensure they’re correct. Once it opens via the run box you can then create the shortcut.

Now when opening the newly created shortcut you should see the database open as normal and presented with a login screen.

  • Pingback: Microsoft Access error – You do not have the necessary permissions « Frustrated IT Engineer()

  • brkthemold

    YOU ARE MY HERO!!!!!

  • joselguerra

    Thank you Chris. However, what credentials do I use to get into the database, when the login screen comes up please?

    • If you’re using a MDW file then username and password would’ve been originally configured… I’m not too sure how you would go about recovering such information or even if It’s possible – Google might be your friend here.

  • Bane

    Can u fix my base , it well be helpfull for me, couse i have big problem on my work. can open my base, it’s very important

  • mitch

    I keep getting this error when I use the above tutorial, what am I doing wrong?

    “microsoft access is unable to open the data access page the path specified was invalid or was too long”

    btw im using access 2003 in windows 7 cause my boss is too cheap to upgrade

    thanks

  • agroni

    can u explain me better this part : replacing MDB/MDW> to where your files are located and the version of Office you are using

  • Jan

    This seems to be the best source I’ve found for this problem. However, I could never get my shortcut to work. This is the shortcut I’m trying to use: “C:Program FilesMicrosoft
    OfficeOffice14MSACCESS” “F:DATA
    FILESMowDataSLMVER1.mdb” /WRKGRP “F:DATA FILESMowDataSYSTEM.mdw” /user – It says no match when I paste it into Run.
    I tried pasting the just the site (F:DATAFILESMowDataSLMVER1.mdb) and I got a list of 2 files SLMVER1.mdb and SLMVER1.mdb.dsn. I don’t know what the .dsn file is so I’m wondering if that’s my problem. If so, how do I get around it.
    Any help would be greatly appreciated.

    • David B

      It should be “C:Program FilesMicrosoft OfficeOffice14MSACCESS.exe” you are missing the .exe part

      • Jan

        You’re right I missed that but I added it and it still is not working???

        • David B

          What version of office do you have? 2010? 2007? Verify that all the paths for the files are exactly correct. Try launching access without any parameters by just using “C:Program FilesMicrosoft OfficeOffice14MSACCESS.exe” Does that work?

          • Jan

            Office 2010. When I plug that into RUN, I get a screen that comes up and has MSACCESS.EXE and msaccess.exe.manifest If I click on MSACCESS.EXE it opens Access

          • David B

            For some reason it sounds like it is searching for the file and not running it. Try just right clicking on the desktop and new->shortcut and paste this into the location box including all the quotes: “C:Program FilesMicrosoft OfficeOffice14MSACCESS.exe” “F:DATA FILESMowDataSLMVER1.mdb” /WRKGRP “F:DATA FILESMowDataSYSTEM.mdw” /user

            Make sure all the spacing etc is correct and then try running the shortcut

          • Jan

            It says The command line you used to start Microsoft Access contains a n option that Microsoft Access doesn’t recognize. Exit and restart Microsoft Access using a valid command line option. I hit OK and then OK again and it openes Access, but gave this message: Microsfot Access can’t find the database “F:DATA.mdb.’ Make sure you entered the correct path and file.

          • David B

            There is something wrong with your spacing and quotes in the line because i got the same error by typing this: “C:Program FilesMicrosoft OfficeOffice14MSACCESS.EXE” “f:data Your line should look exactly like this: http://i.imgur.com/m9ul4ZO.jpg

    • Gaurav

      I have tried this,but one question is that i have linked tables and the MDB are placed on a share drive. I need to change the linking of the tables to a new location.When i try this i get the same error message. How can this be fixed?

  • Steve

    Nope doesn’t work. When you copy and paste the string into creating a shortcut it just says path cannot be found and inserts a load of quotes that breaks the string up. Pathetic f*cking microsoft again. Do you know how much time has been wasted on people trying to get around their shit products and pathetic support. The operating system just can’t handle itself. Just awful………. don’t waste your time!

    • Steve

      Ok heres how to get it working, create the shortcut first that links to the exe only. Don’t bother putting in the extra string to point to the mdw file yet as it will spit it back and error for some stupid reason. save the shortcut and then right click properties and add in the extra string at the end. You should now be able to open the link and will be prompted for username and password.

      I don’t know why MS can’t just make it simple in the initial shortcut creation, but that’s what happens when a bunch of impractical nerds without a clue about user functionality develop a system. Down with MS!!!!

  • Punit

    Its asking password with username “s”.
    But file is not password protected.

  • Pingback: Aprire un DB ad accesso limitato - Access()

  • Andy FIC

    Hello All,
    After creating shortcut there is a prompt to enter Username and Password.
    Which username/password is it expecting?

    I have tried all possible combinations… Didn’t work.
    Can any one help?

  • Demandread

    Hello, I just wanted to say that this article is really well written and it helped me to fix a problem that I had to access a database with this security, thank you