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
4,678 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
  • 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
 

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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

747 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now