Link to home
Start Free TrialLog in
Avatar of timbersnow
timbersnow

asked on

Access You do not have the necessary permissions to use the xxx ... message - How to rebuild the MDW

I've inherited an ACCESS database from a disgruntled developer - that when I try to open it, I get the ...You do not have the necessary permissions to use the xxx ... message.

I know it's because i do not have the original mdw, but i do have the owner name and password.

I need to rebuild the mdw,

Thanks,

Gp.
Avatar of Rick_Rickards
Rick_Rickards
Flag of United States of America image

What you need in addition to the owner's name and password is the 1) Work Group Name, 2) Organization and 3) Case-Sensitive Work Group ID to recreate the .mdw.

If you have these 3 pieces of information run the program called "WRKGADM.EXE" executable found in the SYSTEM32 directory of WINDOWS, enter the 3 items above.
Avatar of timbersnow
timbersnow

ASKER

Rick,

No wrkgradm.exe in the system32 folder.

I'm running Vista 32 - and Office 2007 - which probably explains the whole issue with not having it.  I know A2007 does not use User Level Security any longer - but i cannot find a copy of wrkgadm.exe anywhere to make this happen.

I do have all of the items you specified.  Is there any way somebody could create a mdw for me if i supply all of these things - and if not - point me in a direction to find a copy ow wrkgadm.exe?

Thanks,

Gp.
Avatar of Rey Obrero (Capricorn1)
{User Level Security } try looking here
Database Tools > Administer > Users and Permissions > User-Level Security Wizard
Ya ... but i'm using Access 07 ...

It does not use User Level Security - and hence there is no ULS Wizard.

But ... i did look there just to be certain.

Any other ideas?

I just uploaded Wrkgadm.exe for you to EE stuff.

mx
<I've inherited an ACCESS database from a disgruntled developer ->
In what version of access was the database created?
Have you converted it to Access 2007?
Cap ...he wouldn't be able to convert it because it's secured.

mx
Going to get it now MX ... and you're right ... can't

BRB
MX,

Need msjet35.dll too ... CRAZY

Thanks.

Gp.
ok ... are you sure that's all ... might be more ... check first ... ok ?

timbersnow,
it would be less problem if you can get hold of a computer with A2003 and use it to open your db.
Right ... it would.  I'm not in any vicinity to such a beast.

MX ... don't know ... there might be more. If so, then i'll just eat it.

Thanks
ok ... jet is uploaded ... maybe ... but I got a couple of errors.  Tried Zip and straight DLL
      
Invalid Question value
Invalid file type

see if it's there

Cap --- ditto on your last comment ... but whatever it takes.

mx
MX

weird ... it's not there.

Arghh
I will try from a different system ... hang  on ...

I keep getting:
Invalid Question value  ????  I put in the question ID ... as it says!!
Invalid file type  ????   How zip or dll be invalid ???

Makes no sense ... do you  have a contact email?  

Also ... will 4.0 work?  If not I have 3.5 on another system .. but .. I'm backing up that system right now ... about another 1/2 hour ..

let me know ...
sure ...

you can send to gpdownloads@gmail.com ... that'll work.  Don't know if 4.0 will work ...

And i appreciate everything you're doing here!  Truly.

Cheers,

Gp.
ok .. I  just set (sun 11:00 pst) both files (wkg and jet) to that email address

mx
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Dude ... YOU ROCK!

I appreciate what you've gone through here to accommodate me on this.

I found a laptop that had A2003 on it and i've been using the wizard to create the MDW's ... unfortunately, i'm still getting the same deal.  

Sucks.

Gp.
Did we get a resolution to this question?

mx