Saturday, January 16, 2016

Do not have permissions to use the MS Access MDB object

A user gotten a new laptop and tried to open an Access 2003 database copied from his old laptop.  Much to his dismay, the Access 2003 database failed to open with the following error message.

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

image

This is got to do with the pre-Access 2007 security feature.  If you wish to know more about it, you can check out these two articles.

Here is how we got it resolved

We managed to find the workgroup information file (System.mdw) needed to open the mdb file and copied to the new laptop.

Created a shortcut with the following parameter.

"C:\Program Files\Microsoft Office\Office15\MSACCESS.EXE" "C:\demo\Test.mdb" /wrkgrp "C:\demo\System.mdw"

  • "C:\Program Files\Microsoft Office\Office15\MSACCESS.EXE" is the full path to the MS Access executable.
  • "C:\demo\Test.mdb" is the Access 2003 database file we are trying to open.
  • "C:\demo\System.mdw" is the workgroup information file copied from the old laptop.

Double click on the shortcut and it opened the Access 2003 database.

Now that the Access 2003 database has been opened, the user wanted to remove the security.  He is not aware of the setup since it is an inherited thingy and the person created it is not longer with us.

Here is how we removed the security

With the Access file open, click on “FILE”.

image

Click on “Users and Permissions” and select “User and Group Permissions…” from the drop down menu.

image

Select “Groups” for “List:”. 

Select “Users” under “User/Group Name:”. 

Select everything under “Object Name:”.

For each of the object type (Database, Table, Query, Form, Report and Macro), you will need to grant all the permissions.  Below screen shots show the permissions for the Database, Table and Query object type.

image

image

image

Once you are done with setting the permissions, close the Access 2003 database.  Try re-opeing it directly without using the shortcut and it should open now.

5 comments:

vinu priya said...

Learning new technolgy would help oneself at hard part of their career. And staying updated is the only way to survive in current position. Your content tells the same. Thanks for sharing this information in here. Keep blogging like this. Android App Development Company in Chennai

Akshaysri said...

Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.
Sat Coaching Chennai

Abiya Carol said...

I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be subscribing to your feed and I hope you post again soon.

Digital marketing Course in Chennai

Thamizharasi J said...

I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be subscribing to your feed and I hope you post again soon.

Fresher Jobs in Chennai
Fresher Jobs in Delhi
Fresher Jobs in Bangalore
Fresher Jobs in Kolkata

Evangeline Mitul said...

These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post. Your articles really impressed for me,because of all information so nice.

Laser Root Canal Treatment In Chennai

Best Dental Clinic In Velachery