Solved

Cannot open Access DB: You do not have the necessary permissions to use the object , have your system administrator or the person...

Posted on 2010-11-24
12
5,261 Views
Last Modified: 2012-05-10
Hi, a client sent me an access db (mdb file) along with a mdb.mdw file , and provided me with username master , password "expert" , however when I try to open this mdb file on my access 2007 software, I get the below message. Where should I enter this password information to be able to open the mdb file?? the mdb file is named eggster.mdb and the mdw file is eggster.mdb.mdw and they are both under c:\

You do not have the necessary permissions to use the 'c:\eggster.mdb' object , have your system administrator or the person who created this object establish the appropriate permissions for you.
0
Comment
Question by:eggster34
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 7

Expert Comment

by:RemRemRem
ID: 34207451
It sounds like you're managing to open the DB with your default mdw instead of the eggster one. You may need to open it with that, instead. You can create a shortcut which will tell it to open with the right MWD:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe" "C:\eggster.mdb" /WRKGRP "C:\eggster.mdb.mdw" (assumes you have a standard install location for your Access executable)

-Rachel
0
 

Author Comment

by:eggster34
ID: 34208411
I'm afraid I get the same error message :( I'm using access 2007.
0
 
LVL 7

Expert Comment

by:RemRemRem
ID: 34208531
Can you confirm that the person who gave you the files also stored them at the C: drive level? If not, you need to emulate the folder paths that s/he kept them in, and store your MDW there.

As an aside, if you're going cross version, i.e., it was designed in an earlier one, you may be SOL in terms of using the MDW.

Worst case is, there are MDW breakers out there, but I can't recommend 'em - once you break the egg (no pun intended on your DB name!), you can't unbreak it. However, if you're that level of desperate, a search for such products will likely help you out.

-Rachel

0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

Author Comment

by:eggster34
ID: 34208821
I'm pretty sure they weren't.. I didn't realize this was a requirement.. I'll learn the exact path and try it that way.
0
 

Author Comment

by:eggster34
ID: 34234582
I did exactly as you suggested, but it still gives me the same error despite creating a shortcut and duplicating the path on the actual server.
0
 
LVL 7

Expert Comment

by:RemRemRem
ID: 34240955
Assuming the MDW and MDB were developed in 2007, too, the only idea I have left for you is to confirm both the login and password and specifically, their case sensitivity, which is relevant. (If the files weren't developed in 2007, that may be your issue. Otherwise, I'm out of ideas for you beyond a password breaker software, which I really don't recommend.

-Rachel
0
 

Author Comment

by:eggster34
ID: 34241161
I installed access 2003 (where the db was developed) and nothing changed; where exactly do I enter the username and password? it doesn't prompt me anywhere?
0
 
LVL 7

Expert Comment

by:RemRemRem
ID: 34241203
Hmm. If you're not even getting to the actual login, this may be something even sillier than we've been trying, and not related to Access security. Please go to Explorer, find the MDB file, and right click on it. Check under Properties, and see if it's been set to Read Only. If it has, uncheck that. Do the same to the MDW, though this is less likely your issue. Then try opening again.

-R
0
 

Author Comment

by:eggster34
ID: 34241282
they were not set to read only.

I just receive this message You do not have the necessary permissions to use the 'c:\eggster.mdb' object , have your system administrator or the person who created this object establish the appropriate permissions for you. what ever I do :(
0
 
LVL 7

Expert Comment

by:RemRemRem
ID: 34241505
Argh! Ok, here's another recommendation I saw relative to similar complaints:

"Open Access using the default system.mdw workgroup, start a new database,
and import all the objects from your 'secure' database. It will no longer
be secure."

Not sure if this'll work, but possibly it will just ask you for the user name and password you have, instead of telling you you can't.

You may also want to go back to the person who gave it to you and have them run a test whereby they copy the front end database to another location and try to open it - if they get the same error, it may be about how the permissions were created in the database on an object level.

Without hands on testing, I think I've reached the end of what I can suggest. Good luck!

-Rachel
0
 

Accepted Solution

by:
eggster34 earned 0 total points
ID: 34253813
I went to tools -> security -> workgroup administrator , selected the mdw file, hit Join and successfully joined the workgroup. I was then able to open the file with the supplied username / pass. I appreciate your help but I'm disappointed that you didn't let me know of this basic step / possibility before leading me on to more complicated stuff :(
0
 

Author Closing Comment

by:eggster34
ID: 34281206
I found the solution myself.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question