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

Need permission to open MS Access 2003 mdb file

I have an ms access .mdb file a customer gave me.  His programmer is no longer available and he needs additional coding to be done.  When I try to open the file (I have Access 2007) I get the following message: You do not have the necessary permissions to use the 'c:\temp\workers.mdb' object.  I have a program that shows me all the workgroup user passwords, group IDs, and user passwords.  However, the file isn't asking for a log in or password.  How do I give myself the necessary permissions?

Eric Wilson
0
cerebrumconsulting
Asked:
cerebrumconsulting
  • 6
  • 2
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
So, this mdb has been secured with ULS (User Level Security)?  If so, do you have the corresponding secured MDW file ?

mx
0
 
cerebrumconsultingAuthor Commented:
I have a file called security.mdw which seems to be the only one in the folder with the original mdb file.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
" I have a program that shows me all the workgroup user passwords, group IDs, and user passwords. "

Now, what program is that ?

mx
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You must use the correct workgroup file when you open a secured database. The simplest way is to build a shortcut that uses this workgroup file. Build a new Desktop shortcut, and use this as the Target:

"Full path to msaccess.exe" "full path to your database" /wrkgrp "Full path to your workgroup file"

You should then be prompted to enter a login. Assuming you know the correct login to use, you should be able to open and edit the file. IF you don't know the correct login - we can't really help you any further.
0
 
cerebrumconsultingAuthor Commented:
To SouthMod: Sorry, didn't realize this, but I was wondering why DatabaseMX was asking about the software instead of offering a solution to my problem.

To LSMConsulting: I'll give that a try this morning and let you know how it goes.

THanks,

Eric
0
 
cerebrumconsultingAuthor Commented:
That did it.  Thank you.

Eric
0
 
cerebrumconsultingAuthor Commented:
The questions by DatabaseMX were intrusive and time consuming.
LSMConsulting's answer gave me the solution, but being unfamiliar with access I had to figure out that the workgroup file he was referring to had nothing to do with a Windows workgorup, but rather referred to the Security.mdw file.  I figured that the "w" in the extension identified it as a workgroup file.  No big deal.  
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Since you posted this in your original question:

" I have a program that shows me all the workgroup user passwords, group IDs, and user passwords"

It would be reasonable to assume you know what a "workgroup" is in regard to Access. However, had you posted a comment asking about the workgroup file I could have clarified this for you.

I have requested the Moderators review your "C" grade, as it's inappropriate for the answer I provided.
0
 
cerebrumconsultingAuthor Commented:
The "C" rating shouldn't reflect on you.  As I recall, the question that Experts Exchange asks is how did I rate the experience.  The experience involved all who participated in the answer, not just the winner.  DatabaseMX asked me an inapproriate question which took up my time and didn't contribute to an answer from him.  However, it did get me a reprimand for violating EE policy, though I had acted out of ignorance.  So overall, the experience was not enjoyable, but your help was very much appreciated.  If I had been asked to rate only your answer, I would have given an "A".

Hope this resolves all pending matters.

Eric  
0
 
cerebrumconsultingAuthor Commented:
Thanks for the clarification.

Eric
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 6
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now