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.

Microsoft Office 2010 – Activation, Allow non-admin user to activate manually

If you’re having trouble trying to get Microsoft Office 2010 to activate over a proxy because it times out too quickly and there’s no easy way to get around this, you can grant the user the ability to activate Office 2010 manually which should resolve the issue. By default a user with admin rights will be able to activate office.

The following is displayed when a non-admin user tries to activate Office 2010:

“This action requires Administrator privileges. Please contact a system administrator for future assistance”

To overcome this, you can change a simple registry key:

Start > Run > Notepad

Paste the following:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OfficeSoftwareProtectionPlatform]
"UserOperations"=dword:00000001

File > Save As > Office2010Activation.reg – Save as type: All Files.

This will allow this to be automated via GroupPolicy/ZENworks or something similar.