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,938 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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