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.
timbersnowAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rick_RickardsCommented:
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.
0
timbersnowAuthor Commented:
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.
0
Rey Obrero (Capricorn1)Commented:
{User Level Security } try looking here
Database Tools > Administer > Users and Permissions > User-Level Security Wizard
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

timbersnowAuthor Commented:
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?

0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I just uploaded Wrkgadm.exe for you to EE stuff.

mx
0
Rey Obrero (Capricorn1)Commented:
<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?
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Cap ...he wouldn't be able to convert it because it's secured.

mx
0
timbersnowAuthor Commented:
Going to get it now MX ... and you're right ... can't

BRB
0
timbersnowAuthor Commented:
MX,

Need msjet35.dll too ... CRAZY

Thanks.

Gp.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok ... are you sure that's all ... might be more ... check first ... ok ?

0
Rey Obrero (Capricorn1)Commented:
timbersnow,
it would be less problem if you can get hold of a computer with A2003 and use it to open your db.
0
timbersnowAuthor Commented:
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
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
timbersnowAuthor Commented:
MX

weird ... it's not there.

Arghh
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I will try from a different system ... hang  on ...

0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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 ...
0
timbersnowAuthor Commented:
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.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok .. I  just set (sun 11:00 pst) both files (wkg and jet) to that email address

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
opps ...  I mean SENT ... :-}

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Well ... I got the following error back (note - the attachment was a WinZip File!): (see below) ... HOWEVER ... I did just get EE Stuff to work:


https://filedb.experts-exchange.com/incoming/ee-stuff/2883-WrkgadmAndJet35.zip

Email error - FYI:
I'm sorry to have to inform you that your message could not be
be delivered to one or more recipients. Your original message
is attached below. The reason for failure is listed below.

No further delivery attempts will be made for this message.
To retry delivery, please send the message again.

--- Reason(s) for delivery failure ---

<gpdownloads@gmail.com>: host gmail-smtp-in.l.google.com[64.233.163.114] said:
    552 5.7.0 Illegal Attachment 38si6524898nzf (in reply to end of DATA
    command)

*****************************************
So you have a better email address I can send to?  An FTP site?

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
timbersnowAuthor Commented:
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.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Did we get a resolution to this question?

mx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.