• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6353
  • Last Modified:

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

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
eggster34
Asked:
eggster34
  • 7
  • 5
1 Solution
 
RemRemRemCommented:
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
 
eggster34Author Commented:
I'm afraid I get the same error message :( I'm using access 2007.
0
 
RemRemRemCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
eggster34Author Commented:
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
 
eggster34Author Commented:
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
 
RemRemRemCommented:
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
 
eggster34Author Commented:
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
 
RemRemRemCommented:
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
 
eggster34Author Commented:
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
 
RemRemRemCommented:
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
 
eggster34Author Commented:
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
 
eggster34Author Commented:
I found the solution myself.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now