Re: Locked myself out as administrator



"Joan Wild" wrote:

> Mike G wrote:
> > I use Access 2002 at a Hospital here in Houston. I set up a database
> > using access 2 years ago. I am not necessarily a "computer" person,
> > however because of limited funds I was delegated the job. I recently
> > went into access and deleted a group of students from a workgroup and
> > added some new students.
>
> When you 'went into access' did you log in as the 'administrator'?
Joan, When I set up the Database 2 and one half years ago I set it up
with me as administrator, and also as a user. I've always logged on with my
name and password as a user, which also allowed me to function as the
administrator since I had granted myself those rights. Unfortunately I do not
remember if I had a password as an administrator. I know bad move. Hindsight
is 20/20.
>
> > I'm not exactly sure what i did, however I had
> > done it before and I managed to remain the sytem admin and add the
> > students names and passwords without a problem. After Access
> > generated the new security file
>
> Why did you generate a new security file? You should have just been
> modifying the workgroup file that existed already.

I had some problems in the past with modifying the workgroup and the
Microsoft book "Access step by step" recommends using the security wizard.

> To add/remove users, did you go through the security wizard? Did you just
> use the menus (Tools, Security, Accounts)? What exactly did you do?

Well I originally used the Tools, security, to delete the old students and
then I went through the security Wizard to add the new students. The weird
thing is, the new students passwords don't work, but if they click on "ok"
when it tells them they are not a valid account, it opens the data base
anyway.(??)
>
> > i could not do anything with the data
> > base.....i could log on and access the tables and forms, queries etc,
> > however it would not allow me to edit anything.
>
> Logon as who? The administrator, one of the new student users?
>
Logon on a myself, since I am one of the users also.

> > I assumed I had done
> > something wrong, and attempted to go back into security and run it
> > again but i get a "you do not have permission.." message.
>
> What do you mean by 'run it again'. You should not be repeatedly running
> the security wizard if that is what you mean.
Yes thats what I meant, I ran the security wizard again. Well I
figured since its the Wizard, it could figure out what was wrong
> > I would greatly
> > appreaciate any help someon could offer either directly or pointing
> > me in the right direction
>
> You should be OK. Do a search on your computer - Start, Search for Files
> and search for *.mdw
> Post back with what you find.

Joan I have the following MDW files on the computer, I've included the
size and date modified
System1.mdw 104KB 1/13/2004
System2.mdw 104KB 8/14/2005
Secured.mdw 172KB 7/24/2003
Secured.mdw 412KB 8/5/2005
Secured1.mdw 112KB 8/3/2005
Secured2.mdw 112KB 8/3/2005
Secured3.mdw 112KB 8/4/2005
tcdb.mdb.mdw 104KB 8/5/2005
tcdbperf.mdb.mdw 104 KB 8/5/2005

I think some of these must have been generated when I made my futile
attempts to fix the problem. I had read on a web page after searching for
solutions, that the way to work around my problem was to create another data
base and just copy or export the "old" data base to the new data base. Which
struck me as odd since if its that easy to get around the security, why even
have it?..Needless to say it didn't work..

Thanks for your help.

Sincerely
Mike


>>
>
>
>
.