User has locked himself out of database

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

I have a user who created a database in Access 2002. He decided to
"play around" with security and has completely locked himself and
everyone else out of the database. Now I'm supposed to bail him out.
(Gotta love those users!!)

I believe he has revoked all permissions from everyone - including
Admins. He can not open any table, form, macro or any other object.
It says "no read permissions".

I have been trying to follow some of the suggestions in other threads
and nothing seems to be working. I had him send me any "system*.mdw"
files on his machine - there were three. I tried the following with
each one.

1. Join the workgroup
2. Add a new user
3. Add that user to Admins
4. Remove Admin user from Admins group

When I then login as the new user and try and give permissions to an
object, it says I must have administrator authority to do so.

I've also tried logging in as the new user and running the security
wizard. It seems to hang when I click "finish". I have tried with
just one table and one form but the progress bar seems to stick around
80%.

Any suggestions before I tell the user he's out of luck?
 
Thanks! I've tried all of his mdw files and no luck. Each time I
make myself
a member of the admin group and try and grant permissions on any
object, I get the message
"you must have administrator authority to change this
object"

Is it possible he revoked permissions on everything from the Admins
group too?

I also tried going through the security wizard just changing 1 table
and 1 form and is just stalls. Any thoughts on that?
 
Didn't he fool around with the standard system.mdw
A new Database is basicly hooked up with this MDW.
Looks that he has played around with this file as MDW file.
Because you don't say that he made a new workgroupfile.

Rgds Pieter.
 
Back
Top